Sage odbc error in asp only -

hi

I have posted this twice before but no luck

I noticed another chap had the same problem but I can't contact him by email (Dan4007) its says I don't have the right privileges to do this.



Dan if you're reading this can you get back to me mate and tell me what you did to solve the problem. You didn't really go into what steps you took to solve it







Hi

I recieve the following error



Microsoft[odbc driver manager] data source name not found and no default driver specified



my code is as follows and works fine in excel . I have a user dsn set up called Sage and a system dsn called sage so don't think thats the problem



any help will be well appreciated



Dim sSQL

dim conn,rst

Set Conn = Server.CreateObject("ADODB.Connection")

Set rst = Server.CreateObject("ADODB.RecordSet")

//get error on next line

Conn.Open dsn="Sage", "TestUser", "correctpassword"

i think its a connection problem, u can try this site

http://www.connectionstrings.com/



and i think u can send personal messages to members only after u have made more than 10 posts.

sage is not in connectiontrings.com m8 thanks anyway