Recieve error when trying to use login on remote server

[FireDesigner]

I ran into a problem using login on my site. I ran through all the steps of setting up a connection and creating a dsn, and it works great when I preview it locally. When I post it to the remote server and I try to use to login fuction it gives me this error-

ADODB.Recordset.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified


/certframe.asp, line 14

I understand that it can't find the odbc driver, but the question is how do I get this driver to the remote server? All help is greatly appreciated.

 

[schase]

I havnt used Intersolv or SQL

But with ASP/Access its the DSN Setup.

Either DSN or DSN-Less.

For dsn you need to get your host to set this up for you. Just email them and tell them the name of the database and your connection string name - like connMyDatabase

DSN-Less is a different animal. Here is a pretty good explanation on it.

http://www.tek-tips.com/faqs.cfm?spid=333&sfid=178&CFID=66256725&CFTOKEN=45850988

"I like a man who grins when he fights."

-- Prime Minister Winston Churchill

Stuart