not connecting to database

  • Hi everyone,

    Something weird just happened with my program. I didn't change anything and suddenly a new error message appeared which said that the recordsets could not open. I dig a bit and found the problem: when i'm opening my ADODB connection, the object stays Null. I didn't change my connection string for at least a year and didn't change anything that could cause this problem. Here's the code that open my connection object:

        Set bds = New ADODB.Connection

        bds.Open ConnectionString

        Exit Sub

    My server : sql server 2000 sp3 ( 8.00.760 (Intel X86) )

    What could be causing this problem?? Can it be the number of license that is not sufficient anymore?

    any help appreciated

    Eric

  • what's in de error-collection of bds after the bds.open ?

    err.message, ...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply