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

    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 "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
    62 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

    Re: or vb6?

    thank you very much.
    I'm running Visual Basic 6.0 (Not 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