HI
I have made a .asp guestbook that works with a .mdb database.
Everything works fine on my PC (IIS).
Now i uploaded the page, the DB and the connection but i cant get the connection to work i just keep getting diffrent errors over and over.
If i do this:
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
Set Conn =Server.CreateObject(ADODB.Connection);
strConnection="Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=/Twentyonedays/db/guestbook2000.mdb;Uid="Admin";Pwd="xxxx"";
oConn.Open(strConnection);
%>
I get an error in my connection file:
Microsoft JScript compilation error '800a03ec'
Expected ';'
/twentyonedays/Connections/Guestbook.asp, line 8
Set Conn =Server.CreateObject(ADODB.Connection);
If i do this:
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
strConnection="Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=/Twentyonedays/db/guestbook2000.mdb;Uid=Admin;Pwd=xxxxx";
%>
I get an error in my site (not the connection)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/twentyonedays/Gaestebuch.asp, line 43
Line 43 sais:
rsGuestbook_cmd.ActiveConnection = MM_Guestbook_STRING;
I hope i could give enough information and someone can maybe help me.
Regards
Robin!