Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Post Unanswered: Microsoft SQL server 2000

    I connect to SQL2000 database by Visual Basic. It run well on OS 98 and 2000 but it can't run on window XP with the same configure(MDAC, Visual Basic, Service Pack Version).
    The error occurs when the default database(Initial Catalog) changed as the following code:

    SqlCnn as new adodb.connection
    SqlCnn.open "Connection String" ' Default database is "Product"
    SqlCnn.Default Database = "Customer" ' Error occurs at this line of code.

    Do you have any ideas to solve this problem?
    thank you very much in advance.

  2. #2
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62

    vb.net or vb6?

    obvious questions, but are you running .net or 6? and also, are you sure the DSN is set up properly?

  3. #3
    Join Date
    Sep 2003
    Posts
    3

    Re: vb.net or vb6?

    Hi!
    thank you very much.
    I'm running Visual Basic 6.0 (Not VB.net) and DSN is correct because my program runs well on OS 98 and 2000.
    I hope you'll give me countermeasure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •