DSN connection

[zakd]

.
.
.
Dim data As OleDbConnection
data = New OleDbConnection( "DSN=database" )
data.Open()
.
.
.
Why i get an error message when i'm trying to connect a database with DSN name??
The error message says that i don't specify provider (sqlolebd)...

 

[link9]

.NET now uses either:

OLEDB

-or-

Native providers

ODBC is now gone. So, check out this site:

http://www.connectionstrings.com/

to get what you need to connect. And store your connection strings in your web.config files so you get the portability that a DSN also provides for you.


paul

 

[zakd]

I've done the connection with connection string.

I read about ASP.NET & DSN connection in a book that's why i suprised when i saw the results!
Sometimes books make mistakes..

Anyway thanks for your reply.