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" <Ben@discussions.microsoft.com> wrote in message
news:04C1C471-1245-4270-A8AF-83F8A786598D@microsoft.com...

> Hi,
>
> Is it posssible to connect to Sql Server using DSN?
>
> Thanks,
> Ben
>

[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




"Ken Schaefer" wrote:

> Yes...
>
> Cheers
> Ken
>
> "Ben" <Ben@discussions.microsoft.com> wrote in message
> news:04C1C471-1245-4270-A8AF-83F8A786598D@microsoft.com...

> > Hi,
> >
> > Is it posssible to connect to Sql Server using DSN?
> >
> > Thanks,
> > Ben
> >

>
>
>

[Paul Roberts]

Hi Ben,

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

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

"Ben" <Ben@discussions.microsoft.com> wrote in message
news:04C1C471-1245-4270-A8AF-83F8A786598D@microsoft.com...

> Hi,
>
> Is it posssible to connect to Sql Server using DSN?
>
> Thanks,
> Ben
>