Connect to Sql server using DSN?

[Ben]

Hi,

Is it posssible to connect to Sql Server using DSN?

Thanks,
Ben

 

[Ken Schaefer]

Yes...

Cheers
Ken

 

[Ben]

Hi,

Got to use the odbc .net data provider?

Our application is already using Sql server .net data provider. Is it as
easy as switching to the odbc .net data provider? Will the the codes for the
Sql server .net data provider will work in the odbc .net data provider as
well?

Do you have a sample connection string that utilizes the DSN?

Thanks,
Ben

 

[Paul Roberts]

Hi Ben,

Have a look at this website it has lots of different connection string
examples http://www.able-consulting.com/ADO_Conn.htm

I'll ask a silly question too, why do you need to use a DSN to connect to
SQL server? I is faster to use the .net SQL Server provider.

Cheers
Paul