problems accessing db on live server

[swagtails]

hi folks ...am looking for some help regarding loading up a new site to a live server.

Ive just loaded up a new ASP site to the live server and cannot now access the db. This is my first attempt so I'm probably doing something stupid but this is where I am.

I have loaded the db into the same web folder as the asp pages. In this folder is a sub folder called Connections which points to the db but I am gettinmg the message

ADODB.Recordset.1 error '80004005'

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


/recruitment/index.asp, line 8


Is there something that needs to be 'set' on the server, I'm comletely in the dark but my hosts have just said that ASP is activated ........??

Cheers, Swags

[buntine]

Are you using a Data Source (DSN) to connect to the database? Or are you providing an explicit location and driver?

If you are using a DSN, you will need to have it registered/created on the server. You may need to contact your host for this to be arranged. On the other hand; if you are using a DSN-less connection, you have to make sure you provide a driver that exists.

Can you post your connection string?

Regards.

[swagtails]

Hi,

Yes I'm trying to use a DSN but my host has not set up for a db before so he's new at it too.

this is the code in the Connections file that Dreamweaver put together for me

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_jobsdb_STRING
MM_jobsdb_STRING = "dsn=newjobs;"



'newjobs' is the name of my DSN ( and also the name of my db )

Thanks, swags