Is it the connection?

[lezmin]

Hi

I am just starting with asp, and have already figured out quite a few stumbling blocks along the way. I am very sure this is something really stupid but I just cannot figure it out.

The problem I have now really has me baffled.

When I want to view my asp page, the browser just sits there and looks like it is loading, but nothing is happening. I have checked my connections strings, one using dsn and one dsn-less, but I am pretty sure the connection string is correct.

Here are the connection strings:

Using dsn:

Dim MM_eOrganiser_STRING
MM_eOrganiser_STRING = "dsn=eOrganiser"

...

Function OpenDB()
Dim cnDB 'As ADODB.Connection
Set cnDB = Server.CreateObject("ADODB.Connection&quot
cnDB.ConnectionString = MM_eOrganiser_STRING
cnDB.Open
Set OpenDB = cnDB
End Function

Dsn-less:

Dim MM_eOrganiser_STRING
MM_eOrganiser_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\systemdb\eOrganiser.mdb"

...

Function OpenDB()
Dim cnDB 'As ADODB.Connection
Set cnDB = Server.CreateObject("ADODB.Connection&quot
cnDB.ConnectionString = MM_eOrganiser_STRING
cnDB.Open
Set OpenDB = cnDB
End Function

Any help would be greatly appreciated. If it is not the connection, then what can cause it?

 

[TonyU]

It seems to me you're only opening the connection to the database and not displaying records from it...


[sup]

There's never time to do it right, but there's always time to do it over!
[/sup]

 

[mwolf00]

Through your page, put the following line to see where it is hanging....

response.write 1
response.flush
..
..
..
..
response.write 2
response.flush


etc...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[JamesLean]

It doesn't look like a problem with either of those. I would say the problem is lying somewhere else in your code.

--James