Update:
I am able to connect to the DB now. I found my mistakes.
Still, i would like to be able to connect using the ODBC DSN without coding
the password/user
This is my code:
WORKS: Dim DbConn As New
SqlConnection("server=Matthew\SQLEXPRESS;database= LoginTest;user=logintest;pwd=test")
DOES NOT WORK: Dim DbConn As New ODBCConnection("DSN=LoginTest;")
error: User '' is not associated with a trusted SQL Connection
why can't it use the credentials i set up in the "LoginTest" DSN? Is there
another way?
"sloan" wrote:
http://www.connectionstrings.com/
this has a
DSN
ODBC
since I don't connect that way, I'm not sure if it has exactly what you
want.
but its a hint.
"MATT" <MA**@discussions.microsoft.comwrote in message
news:A6**********************************@microsof t.com...
Using ASP.NET I would like to connect to a database using a System DSN in
ODBC. Will this allow me to make the connection without having to specify
in
the code the server, user, password...etc...? Could someone please give
me
an example of a simple query using this method
Thanks
MATT