March 26, 2002 by Bill Chalmers
On every machine I have tried this on, the resultant string when opened in notepad comes with spaces inbetween each letter, its not a huge point but is there any way to get rid of the spaces??

A Very Useful FAQ..Thanks!!

April 29, 2002 by Ivan Flack

Great FAQ..but the issue of spaces occurs with me also.

A minor niggle

DSN-Less Connection to Access

June 8, 2002 by Peter Kumaschow

I tried under XP and also got the problem with the spaces. It also created a standard Microsoft Access connection. If you are using Access 2000 you will get better performace using a Jet 4.0 connection string like so:

myDSN=myDSN & "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath(accessdb) & ";"
Dim oConn
Set oconn="server".createobject("adodb.connection") myDSN
If Err.Number = 0  Then
Your code goes here
Else 'Database connection failed so show a message
Response.Write "Database unavailable" & "<br>"
Response.Write "Err Number: " & Err.Number & "<br>"
Response.Write "Description: " & Err.Description & "<br>"
End If
set oConn = nothing