Joined: 10 May 2001
|Posted: Wed Jul 14, 2004 1:06 pm Post subject: VDSDB Question
|Hello, I want to connect to a MSSQL Server databade remotly:
Server name: RSAPP
Database name : CanadaDb
Username : me
Password : Testpwd
Now I tried to use VDSDB and create the DSN then to connect... no luck, Any help would be appriciated.
Here is what I used:
db setup,SQL Server,DSN=DBTestTool,UID=me,PWD=Testpwd,DataDirectory=,DBQ=RSAPP
rem establish database connection
Im getting an error 1002 from the DLL...
I had to create the DSN manually with the ODBC tool of Windows
I cant get it to work it seems...