-
Can't query a table ? Error # = 80040E37
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("ASPdb.Pro"
MyDb.dbDAT="SQLservername,Databasename,usernam e,password"
MyDb.dbUnit = 101
MyDb.dbMode="grid"
MyDb.dbSQL="Select * FROM customer"
MyDb.ASPdbPro
%>
-------------------------------------------------------------------------
I appreciate if you could help. Thanks for your time.
Aldo
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|