How to open an upsized SQL Server 7.0 Database through VB6 
Author Message
 How to open an upsized SQL Server 7.0 Database through VB6

We are in the process of upsizing our Access 2000 databases to SQL
Server 7.0.  I was using the DAO object to open the Access Database but
now that the database has been upsized, I know I can't use the Jet
engine.  I have been trying to open the SQL database (*.adp) by means
of the OpenConnection method.  For some reason, the recordsets no
longer seem to want to open using the OpenRecordset method.  I keep
getting an error which states that the Object variable is not set.
What am I doing wrong?  Can someone please show me how to set up the
OpenConnection method so the Recordsets open properly for adding,
updating and deleting?

* Sent from RemarQ http://www.*-*-*.com/ The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

Fri, 09 Aug 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Upsizing SQL 6.5 to SQL 7.0

2. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

3. About upsizing access DB file to MS SQL 7.0

4. Ado Save & Open with SQL server 7.0

5. VB6.0 and SQL Server 7.0 OLAP Active X components -URGENT RESPONSE NEEDED

6. Dates, VB6 and SQL Server 7.0

7. SQL Server 7.0 problem with VB6?

8. SQL Server 7.0/VB6 Problems with bit and checkboxes

9. using DTS to import a text file in SQL Server 7.0 with VB6

10. VB6.0 ODBC Error 3027 SQL Server 7.0

11. Locking in SQL Server 7.0 via VB6

12. Getting SQL Server 7.0 users with ADOX in VB6


Powered by phpBB® Forum Software