Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server

I'll ask the customer to try switching to a connection string starting with
"Provider=SQLNCLI.1;" and see how it goes.(?)

Please check my other reply as well, and let's continue from there. :)

--
Lars-Erik


"Bob Barrows [MVP]" wrote:

Lars-Erik wrote:
Well, I'm stumped. You haven't tried the SQLNaCli provider then?

Me too, that's why I'm here... :D

Wouldn't that be similar to creating an ODBC DSN with the Sql Native
Client driver? (Sorry, wrote Sql Server Native in previous post.. bad
QA)

No, by using ODBC, you are going through an extra layer of software. It is
usually best to use the native provider when one is available and avoid the
obsolet ODBC provider.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: Suddenly ODBC driver does not work
    ... I suggest that you either use a native OLE DB connection string as suggested ... ODBC depends too much on provider-controlled configuration settings. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Suddenly ODBC driver does not work
    ... My internet provider has ... told me to use ODBC with a connection string that is exactly as in the ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... Wouldn't that be similar to creating an ODBC DSN with the Sql Native ... Client driver? ... obsolet ODBC provider. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: How to load data in ListBox using one command from ADODB Recor
    ... Simply use an DSN-less connection string as the ODBC Connection String. ... >> Is there something unique about how you use the ADODB recordset? ... >>> I am using ADODB recordset and has SQL server database. ...
    (microsoft.public.access.gettingstarted)
  • Re: ODBC connection strings - "ODBC;" prefix?
    ... As you can see, if there is "ODBC;" in the connection string, ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vc.database)