PDA

Click to See Complete Forum and Search --> : Searching Access, Databases, DNS error


spg1
Sep 15th, 2000, 01:26 PM
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

spg1
Sep 15th, 2000, 01:28 PM
code:
-------------
line 13: Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")

line 14:
dbGlobalWeb.Open("Employees")

spg1
Sep 15th, 2000, 01:40 PM
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!!!!!!!!!!!!!