DNS, Driver...

[spg1]

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

help!!!!!!!!!!!!


Trying to make a DSN, can I do thid to a local file through control panel then ftp it to my remote server???


Thanks,
SG

[spg1]

Set dbGlobalWeb = Server.CreateObject
("ADODB.Connection")
dbGlobalWeb.Open ("Employees")
--------------------------------
I think this last line is getting the error.

Hi, i may not be able to help u with solid solution, but why dont u try creating a system DSN using the appropriate ODBC driver (remember different drivers for different databases! ). somehow this is just an idea. hope it will help you. sorry if it doesnt. all the best

[Clunietp]

Maybe this...
dbGlobalWeb.Open ("DSN=Employees")

You are usually better off (for simplicity and performance reasons) to use a DSN-less connection string

like this:
dbGlobalWeb.Open "Provider=SQLOLEDB;Data Source=ServerName;UID=UserName;PWD=Password"