I can connect, but I can't run SELECT query

M Mock · #1 (**permalink**) 03-03-08, 10:45

My vb code in my asp file successfully connects to a database I just set up and for which I created a DSN. But the SELECT query says Invalid object name MyTable:

Code:

	Dim oConn
	Dim oRS
	Dim strSQL
	Dim dt
	
	Set oConn = Server.CreateObject("ADODB.Connection")
	oConn.Open dbString
	strSQL = "SELECT MyCol FROM MyTable WHERE MyOtherCol = '" & 1 & "'"
	Set oRS = oConn.Execute (strSQL)

The object/table definitely exists. I can open it in Query Analyzer. Any idea? Permission problem, maybe?

Thanks.

gvee · #2 (**permalink**) 03-03-08, 11:15

Execute suggests an action (INSERT, UPDATE, CREATE...) you need to open the query resultset

www.w3schools.com/ado should get you started

M Mock · #3 (**permalink**) 03-03-08, 11:38

Thank you for the reply.

I don't believe that is my problem. I am running production code. All I did was set up test databases locally and point to them instead of the production ones.

Any other ideas?

M Mock · #4 (**permalink**) 03-03-08, 12:45

It was the DSN configuration that was wrong.

Forever etched in my mind is the importance of that little checkbox that says Change the default database to:

Thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech