Connect to Oracle 10g with VB6 using ADO
I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!

Answer Question   |  May 8, 2013  6:46 AM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6

Local Security for Vista Home Premium – Network Access
Hi there Vista Home Premium – I’ve been trying to configure the local security option for Network Access – sharing and security model for local accounts, to ‘Classic – local users authenticate as themselves’. This PC communicates with another where an account has been created ( user and password (windows authenticate)) and is needed to [...]

Answer Question   |  April 20, 2009  4:51 AM
Authentication, C#, Classic - Local users authenticate as themselves, Desktop security, Local security, Network access, SQL, User authentication, Vista Home premium, Windows Vista

MSHFLEXGRID image editor
Hi I’m trying to build an image editor using MSHFLEXGRID so far I’m able a map a bitmap in mshflexgrid using following technique clr = GetPixel(picOpen.hDC, x, y) mshflexgrid1.CellBackColor = clr now I want to to create Circle ,Square & Paint bucket . But I do not know how to do it. Please help???

Answer Question   |  April 20, 2009  4:20 AM
Image Editor, Microsoft Hierarchical FlexGrid, MSHFlexGrid, Software development

Server environment for .NET applications
Hello guys – quick and easy one I hope! I want to know what server environment is required to host and run .NET applications. Please help, thanks!

Answer Question   |  April 21, 2009  4:17 AM
.NET, .NET applications, Servers

How to config iSQL Plus on computer without a domain
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]

Answer Question   |  April 20, 2009  3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus

Differences between REXX(For IBM Mainframes) and REXX/400(For AS/400)?
Can you please provide the detailed differences between REXX(For IBM Mainframes) and REXX/400(For AS/400)? I am new to REXX/400, so finding bit difficulties to understand it. Thanks in advance, Shameer

Answer Question   |  April 27, 2009  5:42 AM
REXX, REXX/390, REXX/400

backup of MySql with VB.Net
How can i get backup of MySql in VB.Net?

Answer Question   |  April 20, 2009  11:49 AM
Backup, MySQL, MySQL backup, VB.NET

SQL 2008 Identity column values 0
We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

Answer Question   |  April 20, 2009  11:03 AM
SQL, SQL 2008, SQL Identity Column, table identity column

SQLRPG MaTERIAL
I got a task to work on SQLRPG programmes , but I am very new to this environment . Can any one send me any link about : SQL-RPG . I need from scratch. Thanks in Advance.

Answer Question   |  April 20, 2009  9:24 AM
SQL, SQLRPG

Presentation for Apache
I need to give a short and simple presentation on the Apache.. can u help me to find a short and clear description of Apache, where can refer?

Answer Question   |  April 20, 2009  4:19 AM
Apache

Does something similar to Oracle’s optimizer hints exist in SQL Server ?
In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc… Does something similar exist in Microsoft Sql Server ?

Answer Question   |  April 19, 2009  8:59 PM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning

Update field in table from a calculated query field
I have a form attached to a query with calculations. How do I make the calculated values write back to the table?

Answer Question   |  April 24, 2009  8:30 PM
Calculating fields, Query

Pros and cons of composite key as primary key
I guess the title is pretty much the question. Just wondering what the pros and cons might be for using a composite key for a PK rather than a surrogate key. Thanks!

Answer Question   |  April 17, 2009  4:15 PM
composite key, primary key, surrogate key

Multiple Join Update
Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number, prod_group_id number) My [...]

Answer Question   |  April 24, 2009  11:47 AM
JOIN statement, SQL, SQL queries, UPDATE statement

VBA EXCEL 2003 table coding
Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.

Answer Question   |  April 16, 2009  9:13 PM
Excel 2003, Excel Tables, Microsoft Excel, VBA

creating reports with forms/subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and [...]

Answer Question   |  April 19, 2009  5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms

Change year range on ActiveX calendar on Access form
Hi. I want to change the year range on the calendar in microsoft access. At the moment it goes from 1900 to 2100. really annoying! I have the ActiveX Calendar 11.0 version. On the microsoft website it says to add the code: StartDateCalendar.Year = 2001 but how do you do this? the only other thing [...]

Answer Question   |  April 17, 2009  10:01 AM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms

Skype Integration in vb.net application
I have developed one dot net application in which Skype4COM dll reference is added. I have provided the functionality as Conference call, Call Skype user, Changing status etc. successfully in my application. I want to start skype client from my application by providing userid and password which will directly login to the Skype Client.(without showing [...]

Answer Question   |  April 16, 2009  8:58 AM
.NET, Skype, Skype Integration VB.net, VB.NET

How to Serialize data before binding to grid ???
I am using the code given below (uses reflections), If (minfo IsNot Nothing) Then gvResult.DataSource = minfo.Invoke(Activator.CreateInstance(classtype), inputParameterStore) gvResult.DataBind() Else lblErrorMsg.Text = “No method available” End If Here minfo is an object of type methodInfo. It is used to store information (metadata) of a function. I am getting minfo before the If (minfo IsNot Nothing) [...]

Answer Question   |  April 17, 2009  7:27 AM
GridView, serialize

evaluating a range
I am trying to evaluate a formula to return a statement if true. I am having trouble with the syntax. I am working out the number of years service for staff using the formula currentdate-{employment date}/365 What I want to evaludate is whether the result is between 5 and 6. If true I want the [...]

Answer Question   |  April 16, 2009  3:26 AM
Lookup, Programming, SQL