Connect to informix using DSN onlyThis is a discussion on Connect to informix using DSN only within the ODBC forums in Framework and Interface Programming category; I have the following code that is use to connect to a informix db. The DSN is already defined in Control Panel, and it already contain all the necessary info to connect. Set mConnectionArray(UBound(mConnectionArray)) = mWorkSpace.OpenConnection(vbNullString, 0, 0, "ODBC;DSN=MY_DSN;") I used a third party software to connect to it before and all it require from me was to select a DSN name, no need to enter username/password/database name. I wanted to replicated that behavior but if i do not pass that information in the connection string. the connection property will pop up with the username equal to the workspace username ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
07-02-2003, 03:25 AM
| |||
| |||
 Connect to informix using DSN only I have the following code that is use to connect to a informix db. The DSN is already defined in Control Panel, and it already contain all the necessary info to connect. Set mConnectionArray(UBound(mConnectionArray)) = mWorkSpace.OpenConnection(vbNullString, 0, 0, "ODBC;DSN=MY_DSN;") I used a third party software to connect to it before and all it require from me was to select a DSN name, no need to enter username/password/database name. I wanted to replicated that behavior but if i do not pass that information in the connection string. the connection property will pop up with the username equal to the workspace username (which is the wrong username for the DB) and a empty password field. Can anyone tell me what I did wrong? Thanks heaps!  |
 |
| Thread Tools | |
| Display Modes | |
Linear Mode
