Connection String

Results 1 to 2 of 2

Thread: Connection String

  1. #1
    Join Date
    Dec 1969

    Default Connection String

    I can&#039;t seem to get my connection string correct. I have a win2k server and am using an access database. Any help would be appreciated.<BR><BR>Error Message:<BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)<BR>Operation was canceled.<BR>/jessica/Default.asp, line 9<BR><BR>&#060;%<BR><BR>dim strSQL<BR>strSQL="SELECT * FROM Crap"<BR> Set oConn = Server.CreateObject("ADODB.Connection")<BR> oConn.Open "Driver={Microsoft Access Driver (*.mdb)}; Source=c:inetpubwwwrootjessicadbusers.mdb"<BR> Set oRs = Server.CreateObject("ADODB.Recordset")<BR> oRs.Open strSQL, oConn, 3, 3<BR><BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default RE: Connection String

    Try:<BR><BR>provider=Microsoft.Jet.OLEDB.4.0;data source=c:inetpubwwwrootjessicadbusers.mdb;<BR><BR> I have a free online connect string generator at that can help with making these.<BR><BR>Also note that it looks like your db is in web root, if possible you should move it someplace it cannot be downloaded.<BR><BR>regards,<BR><BR>Dave Kawliche<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts