vb5 and Sybase 
Author Message
 vb5 and Sybase

    Hi all!
    Short Problem Description:
    My problem is that my users always have manually choose a DSN every
time they go into their database.  The automatic options are not
working.

    Detailed Promblem Description:
    When I use vba to connect to my Sybase database, the connection only

works if I use dbDriverPrompt and the user is prompted to enter the
DSN.  This is true even when I tell it the correct DSN to use.  For
example, the following works, but requires the user to choose the DSN

strConnect = "ODBC;DSN=Trans2;UID=sa;PWD={*filter*}Ladies"
Set WrkSpaceObj = DBEngine.CreateWorkspace("TmpWrkSpace", "sa", "",
dbUseODBC)
Set ConnectionObj = WrkSpaceObj.OpenConnection("PatIdx", dbDriverPrompt,

False, strConnect)

.... and the following does not work

strConnect = "ODBC;DSN=Trans2;UID=sa;PWD={*filter*}Ladies"
Set WrkSpaceObj = DBEngine.CreateWorkspace("TmpWrkSpace", "sa", "",
dbUseODBC)
Set ConnectionObj = WrkSpaceObj.OpenConnection("PatIdx",
dbDriverNoPrompt, False, strConnect)

I get error 3146 ODBC call failed.

My DSN called Trans2 looks like this:

[ODBC]
DRIVER=Sybase System 11
UID=sa
SRVR=prentis
DB=PatIdx

    Does anyone have any idea how i can fix this?



Mon, 10 Apr 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. VB5 to Sybase 11.0.2?

2. VB5 w/ Sybase SQL

3. VB5 and Sybase System 11

4. VB5 and Sybase ODBC V3

5. VB5: Using Sybase timestamp

6. VB5 and Sybase System 11 (ODBC)

7. VB5 and Sybase SQL

8. VB5 and Sybase SQL Anywhere

9. VB5 and Sybase.

10. VB5 w/ Sybase SQL

11. VB5 access SYBASE fastest driver/Native Driver

12. VB5 to Sybase 11.0.2?


 
Powered by phpBB® Forum Software