Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to VB4 using an ODBC connection

Status
Not open for further replies.

Meeeeeeeeeeeeeeeeeee

Technical User
Apr 10, 2001
3
IE
Can anyone please help. I am upgrading an application from VB3 to VB4. They used a 16bit ODBC connection to connect to sybase and now want to use a 32bit ODBC. My problem is the type of handle to be allocated by SQLAllocHandle. I have replaced all the functions that need to be replaced but what do I call the handle types.

For example, SQLAllocConnect, SQLAllovEnv, SQLAllocStmt has been replaced by SQLAllocHandle that part is fine. The problem is what handle type do I allocate it to. SQLAllocHandle SQLSmallint is a HandleType which is SQL_Handle_Env, SQLHandle is an InputHandle which is SQL_Null_Handle but this is where my problem is, its not telling me what to put for the next SQLHandle it says its an OutputHandlePtr but it doesn't say what to put in for it, it just tells me that it is a pointer to a buffer in which to return the handel to the newly allocated data structure. HELP HELP.

I have searched and searched the web and books but they all tell me the same thing. Does any one have any sample code that might be of assistance. Thanks!!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top