-
Hello,
I am trying your example for a database search, but I am having trouble making the DSN through the ODBC icon. It seems everything is well, but how do I transfer all of this to a remote server that runs my web page? When I select the file through the ODBC icon, I then FTP it up to my server. But when I try to search Employees DB I get an error of:
---------------------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/DaEngine.asp, line 14
--------------------------------------------------------
I appreciate your help on this,
Stan
-
code:
code:
-------------
line 13: Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")
line 14:
dbGlobalWeb.Open("Employees")
-
code:
Help Gurus!!!!!!!!!!!!
What is the difference in the previous code for connecting to a DB and this:
-------------------
Dim DB
Dim rst
Set DB = OpenDatabase("employees.mdb")
Set rst = DB.TableDefs("Employees").OpenRecordset
----------------------------------
Do I need to use this?
----------------------------------
con.open "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=c:\dealer.mdb;"
-----------------------------
Help I'm a rookie!!!!!!!!!!!!!
