Can't query a table ? Error # = 80040E37

[Aldo]

Hi,

I'm using ASPdbPro Eval version, IIS4 & MsSQL7.
I followed one of the sample script featured in the documentation.
But I'm getting this error message when I try to query a table named 'customer'.

---Error Message-----------------------------------------------------------
Error # = 80040E37
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'customer'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

---ASP page---------------------------------------------------------------
<%
Set MyDb = Server.CreateObject(&#34;ASPdb.Pro&#34
MyDb.dbDAT=&#34;SQLservername,Databasename,usernam e,password&#34;
MyDb.dbUnit = 101
MyDb.dbMode=&#34;grid&#34;
MyDb.dbSQL=&#34;Select * FROM customer&#34;
MyDb.ASPdbPro
%>

-------------------------------------------------------------------------

I appreciate if you could help. Thanks for your time.
Aldo

[Mark]

Aldo,
Maybe your table name is spelled wrong. Try this

MyDb.dbSQL = &#34;*&#34; &#39; (Show list of all tables)

See if that helps.
Mark.


------------
Aldo at 2/3/00 5:06:42 AM

Hi,

I&#39;m using ASPdbPro Eval version, IIS4 & MsSQL7.
I followed one of the sample script featured in the documentation.
But I&#39;m getting this error message when I try to query a table named &#39;customer&#39;.

---Error Message-----------------------------------------------------------
Error # = 80040E37
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name &#39;customer&#39;.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

---ASP page---------------------------------------------------------------
<%
Set MyDb = Server.CreateObject(&#34;ASPdb.Pro&#34
MyDb.dbDAT=&#34;SQLservername,Databasename,usernam e,password&#34;
MyDb.dbUnit = 101
MyDb.dbMode=&#34;grid&#34;
MyDb.dbSQL=&#34;Select * FROM customer&#34;
MyDb.ASPdbPro
%>

-------------------------------------------------------------------------

I appreciate if you could help. Thanks for your time.
Aldo

[Aldo]

Hi Mark,

I followed your suggestion ... and I get this as response.

ASPDB error &#39;800a005b&#39;

Object variable or With block variable not set


Pls help & thanks for your time
Aldo


------------
Mark at 2/3/00 10:13:37 AM

Aldo,
Maybe your table name is spelled wrong. Try this

MyDb.dbSQL = &#34;*&#34; &#39; (Show list of all tables)

See if that helps.
Mark.


------------
Aldo at 2/3/00 5:06:42 AM

Hi,

I&#39;m using ASPdbPro Eval version, IIS4 & MsSQL7.
I followed one of the sample script featured in the documentation.
But I&#39;m getting this error message when I try to query a table named &#39;customer&#39;.

---Error Message-----------------------------------------------------------
Error # = 80040E37
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name &#39;customer&#39;.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

---ASP page---------------------------------------------------------------
<%
Set MyDb = Server.CreateObject(&#34;ASPdb.Pro&#34
MyDb.dbDAT=&#34;SQLservername,Databasename,usernam e,password&#34;
MyDb.dbUnit = 101
MyDb.dbMode=&#34;grid&#34;
MyDb.dbSQL=&#34;Select * FROM customer&#34;
MyDb.ASPdbPro
%>

-------------------------------------------------------------------------

I appreciate if you could help. Thanks for your time.
Aldo

[Mark]

Aldo,

1)
Be sure you are running ADO 2.1. To see what version you have now, do this:

<%
set cnn = Server.CreateObject (&#34;ADODB.Connection&#34
response.write(&#34;<BR>ADO Version = &#34; & cnn.Version )
%>

2)
Also, add a statement that says:
Mydb.dbDBType = &#34;SQL&#34;

3)
Try using dbDSN instead of dbDAT.

Let me know if that helps.
Mark.


------------
Aldo at 2/3/00 8:31:21 PM

Hi Mark,

I followed your suggestion ... and I get this as response.

ASPDB error &#39;800a005b&#39;

Object variable or With block variable not set


Pls help & thanks for your time
Aldo


------------
Mark at 2/3/00 10:13:37 AM

Aldo,
Maybe your table name is spelled wrong. Try this

MyDb.dbSQL = &#34;*&#34; &#39; (Show list of all tables)

See if that helps.
Mark.


------------
Aldo at 2/3/00 5:06:42 AM

Hi,

I&#39;m using ASPdbPro Eval version, IIS4 & MsSQL7.
I followed one of the sample script featured in the documentation.
But I&#39;m getting this error message when I try to query a table named &#39;customer&#39;.

---Error Message-----------------------------------------------------------
Error # = 80040E37
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name &#39;customer&#39;.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

---ASP page---------------------------------------------------------------
<%
Set MyDb = Server.CreateObject(&#34;ASPdb.Pro&#34
MyDb.dbDAT=&#34;SQLservername,Databasename,usernam e,password&#34;
MyDb.dbUnit = 101
MyDb.dbMode=&#34;grid&#34;
MyDb.dbSQL=&#34;Select * FROM customer&#34;
MyDb.ASPdbPro
%>

-------------------------------------------------------------------------

I appreciate if you could help. Thanks for your time.
Aldo

[Aldo]

Hi Mark,

It does help !!! Thanks for your time ... I appreciate it!

------------
Mark at 2/9/00 10:36:06 AM

Aldo,

1)
Be sure you are running ADO 2.1. To see what version you have now, do this:

<%
set cnn = Server.CreateObject (&#34;ADODB.Connection&#34
response.write(&#34;<BR>ADO Version = &#34; & cnn.Version )
%>

2)
Also, add a statement that says:
Mydb.dbDBType = &#34;SQL&#34;

3)
Try using dbDSN instead of dbDAT.

Let me know if that helps.
Mark.


------------
Aldo at 2/3/00 8:31:21 PM

Hi Mark,

I followed your suggestion ... and I get this as response.

ASPDB error &#39;800a005b&#39;

Object variable or With block variable not set


Pls help & thanks for your time
Aldo


------------
Mark at 2/3/00 10:13:37 AM

Aldo,
Maybe your table name is spelled wrong. Try this

MyDb.dbSQL = &#34;*&#34; &#39; (Show list of all tables)

See if that helps.
Mark.


------------
Aldo at 2/3/00 5:06:42 AM

Hi,

I&#39;m using ASPdbPro Eval version, IIS4 & MsSQL7.
I followed one of the sample script featured in the documentation.
But I&#39;m getting this error message when I try to query a table named &#39;customer&#39;.

---Error Message-----------------------------------------------------------
Error # = 80040E37
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name &#39;customer&#39;.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S0002
NativeError = 208

---ASP page---------------------------------------------------------------
<%
Set MyDb = Server.CreateObject(&#34;ASPdb.Pro&#34
MyDb.dbDAT=&#34;SQLservername,Databasename,usernam e,password&#34;
MyDb.dbUnit = 101
MyDb.dbMode=&#34;grid&#34;
MyDb.dbSQL=&#34;Select * FROM customer&#34;
MyDb.ASPdbPro
%>

-------------------------------------------------------------------------

I appreciate if you could help. Thanks for your time.
Aldo