If you prefer to use a built-in MS program you might try out to shell out SQLCMD , and capture the output.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Jones Sent: Tuesday, April 15, 2008 7:15 AM To: [email protected] Subject: [U2] SQL Server 2000 -- Connection I've recently start experimenting with accessing a SQL Server 2000 database from within my UniData program. I'm running on Windows XP SP2. I have modified a copy of the BCI.DEMO program delivered with my downloaded UniData 7.1 Personal Edition to point to my ODBC database. When I attempt to connect using the first three steps: 1) SQLAllocEnv to allocate the database environment. 2) SQLAllocConnect to allocate the connection environment 3) SQLConnect to connect to the database, I get an error message indicating a Status of -1 --> Error occurred. SQLSTATE , NATCOD are:08003. I've verified my ODBC resource by connecting to it from Excel. I've also set up an ODBC resource pointing to a UniData table and that works. Can someone point me in the right direction to determine why my connection isn't working? Is there more I should do to prove the ODBC resource is working correctly? Thanks, Steve ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
