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
>
Changing Sql7 TCP Port ... If the website is running on the same machine as the sql server, and the DSN...connection string in each website has the IP address hard coded and no port ... (microsoft.public.sqlserver.security)
Re: dsn connection ... of processing and file IO to accomplish the same thing. ... All a DSN does is ... store information that you can put right into your Connection String.... > points to the SQL Server and DB? ... (microsoft.public.dotnet.framework.aspnet)
Re: Client applications ... and you'll find many ways to build a connection string without a DSN.... I have been given the responsibility of upgrading a client application ... with database authentication with SQL Server.... (comp.databases.ms-sqlserver)
RE: How do I configure Analysis Services for Excel 2003 users? ... they had had Office 2003 installed AFTER SQL Server.... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ... (microsoft.public.sqlserver.olap)
cannot access website ... Nerve.com--this started a few weeks ago; I do not get the error message on ...Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d' ... Not defined as a valid user of a trusted SQL Server connection.... The DSN used to connect to the Commerce database is misconfigured to use ... (microsoft.public.windows.inetexplorer.ie6.browser)
