Error - Data source name too long

[MadJock]

I get the above error with this code -

<%
set conn = server.createobject(&quot;ADODB.Connection&quot
conn.open(&quot;Driver=Microsoft.Jet.OLEDB.3.51; Data Source=l:\qm2000\iqms\tables\iqmstables.mdb&quot
%>

Does anyone know of a way round this? I can't move the database as it is used by several applications.

Thanks in advance,
Graeme website:

http://www.graeme-taylor.co.uk

 

[link9]

Looks like you may have just fogotten your first &quot; in the location specs there.

So that:

set conn = server.createobject(&quot;ADODB.Connection&quot
conn.open(&quot;Driver=Microsoft.Jet.OLEDB.3.51; Data Source=&quot;l:\qm2000\iqms\tables\iqmstables.mdb&quot


paul

 

[MadJock]

Thanks Link9,

But you have 3 quotes in the string - doesn't work! The path to the database is part of the connection string aswell.

Cheers,

Graeme website:

http://www.graeme-taylor.co.uk

 

[link9]

True. Try this syntax:

dim con, strCon
set con = server.createObject(&quot;ADODB.Connection&quot
strCon = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=l:\qm2000\iqms\tables\iqmstables.mdb;Persist Security Info=False&quot;
con.open strCon

Just got it from the udl builder in win2k, so hope it works for you.

paul