asp.net security: Connect to Sql server using DSN? -- asp.net security

Re: Connect to Sql server using DSN?

Ben
9/9/2004 12:31:11 AM

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

[quoted text, click to view]

Re: Connect to Sql server using DSN?

Ken Schaefer
9/9/2004 4:21:18 PM

Yes...

Cheers
Ken

[quoted text, click to view]

Re: Connect to Sql server using DSN?

Paul Roberts
9/10/2004 9:36:41 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the asp.net security group.