problem with connection string

  • Thread starter Thread starter Neil MacMurchy
  • Start date Start date
N

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
 
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
 
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
 
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
 
Shouldn't you have the Provider as well?

Try:

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