I am tring to write series of waveforms to a database. The DB tools doesn't work with Microsoft SQL, but when i replace the SQL with Access, it works fine. I have to use SQL in the application. Any advice pls?
I don't use it myself, but what I can tell you is that on the
installation CD are a number of readme's and a special folder about SQL
compatibility. There is even some fix executable on it. I suggest you
check that out.
Right off hand I would say the problem is that you are connecting through ODBC. Try the native SQL Server driver, your connect string should define the provider as "SQLOLEDB.1".
Mike...
Certified Professional Instructor Certified LabVIEW Architect LabVIEW Champion
yes mikeporter, you are really right, it does work fine after i put a .udl file created using the driver "Microsoft OLE DB Provider for SQL Server". Thanks very much!
