| tread684 2004-02-23, 1:28 am |
| This may not really be reated to Utra CArt II other than i am trying to get it
work. I changed servers and the new server doesn't use a DSN. Instead the
kindly supplied the following code:
<%
Dim DBPath,objRS,objConn
DBPath="/file.mdb"
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.mappath(DBPath)
objConn.Open
Set objRS=Server.CreateObject("ADODB.Recordset")
%>
which i mutated into the file (asims.asp) that was previously used for
database connection in the "connections" folder:
<%
Dim DBPath,objRS,objConn
DBPath="/file.mdb"
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.mappath(DBPath)
objConn.Open
Set objRS=Server.CreateObject("ADODB.Recordset")
%>
yes this works, and I can see that existing code is accessing the database and
performing the different operations. now...
locally, dreamweaver mx, in the application windows under the database tab is
no longer showing the database or fields.
any ideas? Thanks
|