problem with connection string

[Neil MacMurchy]

Sorry for the x-post



I'm working on changing my connection routine so it isn't reliant on a DSN
on the machine and I've run into a little problem. When I try to connect
with the following connection string I get an error:



Driver=SQL Server;Server=Gomez;Database=RMNWaste;UID=RMNWaste;PWD=Y828Jgw3;



The error: Run-time error '3170' - Could not find installable ISAM.



Neil MacMurchy

Senior DBA

Region of Niagara

 

[Neil MacMurchy]

This is thru Access 2002 not from ASP. conecction string is from VBA code.

 

[Igor Shekalev]

Hello Neil,

What kind of tool you are using to access SQL Server? MS Access or from ASP
script?

NM> I'm working on changing my connection routine so it isn't reliant on
NM> a DSN on the machine and I've run into a little problem. When I try
NM> to connect with the following connection string I get an error:

NM> Driver=SQL
NM> Server;Server=Gomez;Database=RMNWaste;UID=RMNWaste;PWD=Y828Jgw3;
NM> The error: Run-time error '3170' - Could not find installable ISAM.

Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC,IDAPI and OCI
support

 

[James Rasmussen]

Hi Neil,

I am using the following....

Dim myCn As New ADODB.Connection
Dim myRst As New ADODB.Recordset


myCn.ConnectionString = "Provider=sqloledb;data source=xxx;initial
catalog=xxx;user id=xxx;password=xxx"
myCn.Open

sqlstr = "Select * from Accounts"
myRst.Open sqlstr, myCn, adOpenDynamic

Give that a try!
HTH
Jim

 

[Igor Shekalev]

Hello Neil,

Try to test your connection by ODBC Driver manager.
I dealed with this problem but for access to local databases (using Jet DB).
MSKB articles Q283881 and Q290173 discribe problems like this, but not for
MS SQL.

NM> This is thru Access 2002 not from ASP. conecction string is from VBA
NM> code.

NM>>> Driver=SQL
NM>>> Server;Server=Gomez;Database=RMNWaste;UID=RMNWaste;PWD=Y828Jgw3;
NM>>> The error: Run-time error '3170' - Could not find installable
NM>>> ISAM.

Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC,IDAPI and OCI
support

 

[Van T. Dinh]

Shouldn't you have the Provider as well?

Try:

Provider=MSDASQL;Driver=SQL Server;
Server=Gomez;Database=RMNWaste;
UID=RMNWaste;PWD=Y828Jgw3;