microsoft data control 6.0 sp6 oledb connection error

[Uri Dimant]

Hello
Old application that uses microsoft data control 6.0 sp6 oledb getting error
on Windows 7 on connection string to SQL Server 2005

Provider=SQLOLEDB.1;Data
Source=servername,1111;uid=user;app=app;pwd=pass;database=db;"


Please note that conection string contains non default port (which is caused
to the error)

[MikeD]

Post by Uri Dimant
Hello
Old application that uses microsoft data control 6.0 sp6 oledb getting error
on Windows 7 on connection string to SQL Server 2005
Provider=SQLOLEDB.1;Data
Source=servername,1111;uid=user;app=app;pwd=pass;database=db;"

What's the error? Kind of an important bit of information to provide, don't
you think?

You're using the OLE DB Provider for SQL Server 2000. Don't know if it will
solve the problem or not, but you could try using the SQL Server Native
Client. If you need to download that, you can do so here:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc

(scroll down the page to Microsoft SQL Server Native Client)

Other than that, my best suggestion is to ditch the data control entirely.
Also, you might want to ask in a SQL Server newsgroup. There could be
security issues that need dealt with and they'd know what those are better.

[Uri Dimant]

Thank you Mike

Post by MikeD

Post by Uri Dimant
Hello
Old application that uses microsoft data control 6.0 sp6 oledb getting error
on Windows 7 on connection string to SQL Server 2005
Provider=SQLOLEDB.1;Data
Source=servername,1111;uid=user;app=app;pwd=pass;database=db;"

What's the error? Kind of an important bit of information to provide,
don't you think?
You're using the OLE DB Provider for SQL Server 2000. Don't know if it
will solve the problem or not, but you could try using the SQL Server
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc
(scroll down the page to Microsoft SQL Server Native Client)
Other than that, my best suggestion is to ditch the data control entirely.
Also, you might want to ask in a SQL Server newsgroup. There could be
security issues that need dealt with and they'd know what those are better.
--
Mike

[MikeD]

Did that help?

Post by Uri Dimant
Thank you Mike

Post by MikeD

Post by Uri Dimant
Hello
Old application that uses microsoft data control 6.0 sp6 oledb getting error
on Windows 7 on connection string to SQL Server 2005
Provider=SQLOLEDB.1;Data
Source=servername,1111;uid=user;app=app;pwd=pass;database=db;"

What's the error? Kind of an important bit of information to provide,
don't you think?
You're using the OLE DB Provider for SQL Server 2000. Don't know if it
will solve the problem or not, but you could try using the SQL Server
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc
(scroll down the page to Microsoft SQL Server Native Client)
Other than that, my best suggestion is to ditch the data control
entirely. Also, you might want to ask in a SQL Server newsgroup. There
could be security issues that need dealt with and they'd know what those
are better.
--
Mike