i am Using VB 6.0 with SQL Server 2000. It is Possible From VB to Create dynamic DSN for a Access DB. Is It Possible for the SQL Server DB to Create a Dynamic DSN through VB.? If Yes, Please help me..
2006-06-25 23:18:43 · 4 answers · asked by mani m 1 in Computers & Internet ➔ Programming & Design
DSN is just some reg keys on the local machine, you can write them into the registry dynamicly, not really secure but it gets your problem solved.
2006-06-25 23:26:56 · answer #1 · answered by punkypoos 2 · 1⤊ 0⤋
First you must define your DSN in this location and then it will be availabe in it :
control panel -> administrative tools -> data source odbc -> system dsn(tab)
depent on kind of databse create your DSN
yes it's possible.
2006-06-26 07:18:26 · answer #2 · answered by Spitrabergâ?¢ 4 · 0⤊ 0⤋
Why use a DSN at all? OleDb connection strings let you reach a database directly.
2006-06-26 10:37:13 · answer #3 · answered by evolver 6 · 0⤊ 0⤋
Man oh man learn it yourself here
http://www.google.co.uk/search?hl=en&q=VB+and+SQL+Server+%2BDSN&btnG=Search&meta=
2006-06-26 06:47:44 · answer #4 · answered by Joe_Young 6 · 0⤊ 0⤋