SQL SERVER 7.0

[krishnamu@my-deja.com]

Hi

I am attempting to connect to SQL server 7.0 using LabVIEW 5.1 and SQL
toolkit. I can connect using the ODBC driver each time without error.
However, when I send a simple select command such as

SELECT TestNum FROM MasterTable;

I get the following error

Server]Invalid column name 'TestNum'.[Microsoft][ODBC SQL Server Driver]
[SQL Server]Statement(s) could not be prepared.

I also cannot get any information using the sql information VIs other
then the Table names from the database. The column information VI,
which I rely upon, does not return any information.

Does Anyone have any suggestions?

Thanks in advance




Sent via Deja.com
http://www.deja.com/

[Dennis_Knutson]

One thing to check is see whether you have all of the access rights that you
need. You should also use Enterprise Manager (or have the database administrator
do it) to verify that the column names are correct.

krishnamu@my-deja.com wrote:
>Hi>>I am attempting to connect to SQL server 7.0 using LabVIEW 5.1 and SQL>toolkit.
I can connect using the ODBC driver each time without error.>However, when
I send a simple select command such as>>SELECT TestNum FROM MasterTable;>>I
get the following error>>Server]Invalid column name 'TestNum'.[Microsoft][ODBC
SQL Server Driver]>[SQL Server]Statement(s) could not be prepared.>>I also
cannot get any information using the sql information VIs other>then the Table
names from the database. The column information VI,>which I rely
upon, does
not return any information.>>Does Anyone have any suggestions?>>Thanks in
advance>>>>>Sent via Deja.com>http://www.deja.com/

[wiebe@CARYA]

Hi,

you could try this:

SELECT TestNum FROM dbo.MasterTable;

I've always put dbo in front of it, and it always worked fine.

Regards,

Wiebe Walstra.

--
AIR technical Automation
www.air.nl
wrote in message news:95r2i8$uld$1@nnrp1.deja.com...
Hi

I am attempting to connect to SQL server 7.0 using LabVIEW 5.1 and SQL
toolkit. I can connect using the ODBC driver each time without error.
However, when I send a simple select command such as

SELECT TestNum FROM MasterTable;

I get the following error

Server]Invalid column name 'TestNum'.[Microsoft][ODBC SQL Server Driver]
[SQL Server]Statement(s) could not be prepared.

I also cannot get any information using the sql information VIs other
then the Table names from the database. The column
information VI,
which I rely upon, does not return any information.

Does Anyone have any suggestions?

Thanks in advance




Sent via Deja.com
http://www.deja.com/