[lordmerlin]

I recently took over a site from someone else, written in ASP. The global.asa file contrains the DB connection string, yet I haven't seen this before.
When I try and load the site, it gives me an internal 500 error, and the following:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
//global.asa, line 20

This is taken from the global.asa file:

Sub Application_OnStart
Application("hellopeter") = "DSN=hellopeter2;UID=username;PWD=password"
Application("Datasource") = "DSN=hellopeter2;UID=username;PWD=password"
Application("question") = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID='username';Password='password';Initial Catalog='catalogue name';Data Source=remote host"

End Sub

I haven't seen anything like this before. Can anyone please direct to to some answers? I haven't done any ASP.NET coding b4, so I'm not sure if this is ASP.NET, if it is, what do I need todo to get this site working on my PC, so I can work on it?

[GO4TF4CE]

its not asp .net, its classic asp. The global.asa file is basically used to control when sessions are started and ended, for likes of shopping carts etc.

You would need to specify what database type your are using, so you get this going. If you let us know what database your using I'll try to give you the solution.

Cheers

Originally Posted by lordmerlin

I recently took over a site from someone else, written in ASP. The global.asa file contrains the DB connection string, yet I haven't seen this before.
When I try and load the site, it gives me an internal 500 error, and the following:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
//global.asa, line 20

This is taken from the global.asa file:


I haven't seen anything like this before. Can anyone please direct to to some answers? I haven't done any ASP.NET coding b4, so I'm not sure if this is ASP.NET, if it is, what do I need todo to get this site working on my PC, so I can work on it?

[Morritt]

look at line 20, if for example it is the one that declares "Datasource", go to "Adminstratove Tools > Data Sources (ODBC)".

get a copy of the database and setup "Datasource" to point to this file, then you can use it on your local machine and on the server without changing any code.

[AllQuickfix]

**************************
Sub Application_OnStart
Application("hellopeter") = "DSN=hellopeter2;UID=username;PWD=password"
Application("Datasource") = "DSN=hellopeter2;UID=username;PWD=password"
Application("question") = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID='username';Password='password';Initial Catalog='catalogue name';Data Source=remote host"
*******************************************

It seems like they are minataining connection string values in appliaction level.

You have to give corect MS SQL Server connection details to make it work, mainly remote host value should be provided.

Saran