Urgent : VB6 ADO Connecting to SQL 6.5 
Author Message
 Urgent : VB6 ADO Connecting to SQL 6.5


Could anyone please help with the following problem?

I've created an application which uses VB6 (sp1) and ADO to connect to SQL
6.5 (sp4) on NT4 (sp4). Everything works on the development box with the app
connecting to the SQL Server and retrieving recordsets.

I then re-created the database on the Live server which is NT4(sp4) and SQL
6.5(sp4) and moved the test data across. If I then change the server
reference to the Live box which is on a different domain the program seems
to connect as I don't get any connection errors, but when retrieving the
first recordset gives the error 'Invalid Object 'KEY_REASONS' (which is one
of my SQL 6.5 tables).

I can connect to the Live server via ISQL so It's not anything to do with
the link.

Yesterday I went to the Live domain and installed the software on a users
machine for user acceptance testing and exactly the same thing happened. In
the end I pointed the user back to the Test server which worked fine even
though it's on a different domain.

Even though both the boxes seem to have the same software on them the live
server (which was built by a different dept) seems to have something

Does anyone know if any particular services are required for ADO to connect
to NT4/SQL6.5?  We do have some existing apps which use ODBC and we don't
seem to have any problems it's just ADO onto the Live box.

Does anyone have any ideas?

Thanks in advance,


Wed, 04 Jul 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. ado vb6 sql 6.5 trusted connect failure

2. SQL Server 6.5 & VB6 ADO

3. vb6 ado trusted connection to sql 6.5

4. Problem usind ADO VB6 x SQL 6.5

5. ADO 2, OLE-DB for ODBC, SQL 6.5, VB6: Performance Issues

6. Pls Help-VB4 w/SQL 6.5 can't connect

7. ODBC Connect to SQL server 6.5

8. VB 5 and SQL 6.5 ( Urgent!! please help)

9. connecting to MS SQL Server 6.5 using VB5

10. Connect to SQL-Server 6.5

11. Connect to 2 different SQL Server 6.5 db

12. !!! VERY VERY URGENT !!! pb with SQL server 6.5


Powered by phpBB® Forum Software