| View previous topic :: View next topic |
| Author |
Message |
Aslan
Valued Contributor
Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA
|
 Posted: Mon Feb 14, 2005 12:06 am Post subject: VDSDB.DLL and MS SQL Server |
 |
|
Has anyone successfully connect to a MS SQL Server with the vdsdb.dll?
Or more specifically, create a DSN to a MS SQL Server using vdsdb.dll's DB SETUP command.
If so, please show me a sample use of this command to create a SQL DSN.
Thanks in advance,
Aslan |
|
| Back to top |
|
 |
marty
Professional Member
Joined: 10 May 2001
Posts: 789
|
| Posted: Mon Feb 14, 2005 2:33 am Post subject: |
|
|
I will try to find some code for you, but I kept getting ODBC errors using VDSDB...
Seems that connecting thru ODBC is not really reliable..
So we ended it using Delphi (not VDS) and a real SQL server component. |
|
| Back to top |
|
|
Aslan
Valued Contributor
Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA
|
| Posted: Mon Feb 14, 2005 4:32 am Post subject: |
|
|
Thanks Marty,
If I create the DSN manually (In the Windows Control Panel)
I can connect to the remote SQL server just fine.
My problem is that I don't want the end user to have to manually configure ODBC sources. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
@vdsworld