Connecting to a database (SQL Server 7.0)

[computergeek]

Hello,

I am fairly new to using Interdev, and I am having trouble establishing a connection to the database. Am I required to setup an ODBC connection? I hope not this is going to be an Internet application. Error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/VMISYSTEM/Navigation.asp, line 27

Navigation.asp File:
' create and open the Connection object
Set dbUser = Server.CreateObject("ADODB.Connection&quot
dbUser.Open Session("Conn1_ConnectionString&quot, _
Session("Conn1_RuntimeUserName&quot, _
Session("Conn1_RuntimePassword&quot

Global.asp file:
Sub Application_OnStart
'==Visual InterDev Generated - startspan==
'--Project Data Connection
Application("Conn1_ConnectionString&quot = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Sensys;Data Source=KCDEVSQL7;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=userx;"
Application("Conn1_ConnectionTimeout&quot = 15
Application("Conn1_CommandTimeout&quot = 30
Application("Conn1_CursorLocation&quot = 3
Application("Conn1_RuntimeUserName&quot = "sa"
Application("Conn1_RuntimePassword&quot = ""
'-- Project Data Environment
'Set DE = Server.CreateObject("DERuntime.DERuntime&quot
'Application("DE&quot = DE.Load(Server.MapPath("Global.ASA&quot, "_private/DataEnvironment/DataEnvironment.asa&quot
'==Visual InterDev Generated - endspan==
End Sub

 

[Metka]

Hi,

have you tried Microsoft's

http://support.microsoft.com/default.aspx?scid=kb;en-usQ306345

The ;en-usQ306345 is also part of the link, so just copy the whole thing.



"Defeat is not the worst of failures. Not to have tried is the true failure."
-George E. Woodberry

 

[computergeek]

Hi,

I figured out that my Global.asa file is not firing... why I don't know yet.

 

[MerlinB]

A typical answer is that the DSN is configured on your PC (so it works in VI) but not on the Server (so it fails when you try running it in Master mode). Ensure the DSN is configured on the Server.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[computergeek]

Hi,

It's firing on the Master not within the local mode. I am using OLE not ODBC, so a DSN is not required. Still have not figured out why the local global.asa is not firing... for a testing work-around I am running the master mode copy after I have "released the working copy" to the master.

I have tried a few things...with no luck!

 

[MerlinB]

There should only be 1 global.asa, and it should be in the application root directory. I would be very surprised if it is not called...

Please note, your connection stuff in the page code uses SESSION but global.asa uses APPLICATION.

Use a recordsetDTC - even if you dump the dtc, it generates the correct code for you.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)