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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: ADODB.Connection object not returning correct ConnectonString
    ... we have some old COM components that require the ODBC. ... Our application takes the OleDB provider and converts it to an ODBC ... Why not pass the connection string itself to the COM components and let them ... 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)