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/
