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 an ODBC driver using VB4

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 an ODBC connection to connect to sybase/oracle. My problem is the handle types. I have replaced all the functions that need to be replaced but what do I call the handle types.

For example, SQLAllocConnect has been replaced by SQLAllocHandle now it says the SQLReturn 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.

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 for reading this message!!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top