• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

VB & SQL Problem

Hi,

   I'm running a program that loads data into an SQL Server DB.  It reads from a text file and chops up each line to the respective fields and then inserts it into the database.

  Recently, halfway through the loading, I hit a problem and I get the following errors from ODBC.  

ERROR NUMBER  ERROR DESCRIPTION
------------         -----------------
0            
5701          01000: [Microsoft][ODBC SQL Server Driver][SQL
                             Server]Changed database context to        
                             'dbDVSTemp'.
5703          01000: [Microsoft][ODBC SQL Server Driver][SQL
                            Server]Changed language setting to
                            'us_english'.
5701          01000: [Microsoft][ODBC SQL Server Driver][SQL
                            Server]Changed database context to
                            'dbDSSDevt'.


Can anybody help me cos' I'm stumped!! Thanks!

                         Puay Aun
0
palim
Asked:
palim
  • 2
1 Solution
 
Jon_RaymondCommented:
Are you using an ODBC DSN to make the connection?  If so does it point to the correct database, or has SQL Server been reinstalled since the ODBC connection was created?  I'm thinking that your connection doesn't see the database or server settings it expects.
0
 
palimAuthor Commented:
Yeas I'm using ODBC, and yes it points to the correct DB.  No it hasn't been reinstalled.  I've even removed the DSN and re-created it.  Same problem.
0
 
palimAuthor Commented:
Yeas I'm using ODBC, and yes it points to the correct DB.  No it hasn't been reinstalled.  I've even removed the DSN and re-created it.  Same problem.
0
 
simonsabinCommented:
This is an informative message provided by the SQL server driver. It should thus be treated as such i.e just carry on.

What happens is a user has a default database, when you try to connect to another database it will give you that message. Just to be sure when the message occurs check the current database is still the one it should be and then resume next.

I think it does not happen with the latest MDAC.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now