Error 4149 occurred at Fetch Next Record, SQL Server 7.0, and SQL Toolkit 5.0

[biographie]

I am using SQL Toolkit 5.0 and Microsoft SQL Server 7.0. First is their any new drivers for this? Next, I don't seem to have any problems connecting or quering the database for table names or list, or even creating or dropping tables. When I try to retrieve data I use the simplest command "SELECT * FROM MyTableName", and I get this: Error 4149 occurred at Fetch Next Record. I am stuck because trying to debug the Fetch Next Record.vi only takes me to ni's driver call, help!

[Dennis_Knutson]

To answer your first question, 5.0 is the latest version of the SQL Toolkit but there is a new toolkit called Database Connectivity Toolset. I don't have it yet but I do know that there is cost to upgrade.

To answer your second question, error 4149 is created by Connect.vi and the error message says "Connect - Data source name not specified." I don't know if _SQLCIN.vi will generate the same error code. Without seeing your VI and your database, its hard to say any more. Double check your datasource name, connection parameters, and verify that you have the priveleges you need. Good Luck.

[JellyBeans]

Make sure that you don't have NVARCHAR datatype in that table that you are trying to query. have seen this happening.
This prob, is fixed in the new Database Connectivity Toolset though..

A Rafiq

[GL]

It worked!

[gudmfrei]

It worked, thank you

[kellie]

Thankyou! That's exactly what the problem was.