Silly Connection object 
Author Message
 Silly Connection object

    Can somebody please tell me why this code doesn't work, I just hate the
connectionstring-way to open a connection ...

    Set gcnnTVB = New ADODB.Connection

    With gcnnTVB
        .Provider = "Microsoft.Jet.OLEDB.4"
        .Properties("Data Source").Value = "C:\TVB\TVB.mdb"
        .Open
    End With



Tue, 07 Sep 2004 21:29:05 GMT  
 Silly Connection object
Ok, ok, I forgot the ".0" in the provider string



Quote:
>     Can somebody please tell me why this code doesn't work, I just hate
the
> connectionstring-way to open a connection ...

>     Set gcnnTVB = New ADODB.Connection

>     With gcnnTVB
>         .Provider = "Microsoft.Jet.OLEDB.4"
>         .Properties("Data Source").Value = "C:\TVB\TVB.mdb"
>         .Open
>     End With



Tue, 07 Sep 2004 21:31:49 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Silly question or silly compiler ?

2. SOMEWHAT SILLY QUESTION: a Custom COM object, hosted by MTS, exposing an event

3. ***Silly** Duplicating an OBJECT!!!!!!!!! ***

4. ***Silly** Duplicating an OBJECT!!!!!!!!! ***

5. ***Silly** Duplicating an OBJECT!!!!!!!!! ***

6. Connection String vs. Connection Object

7. Connection Errors via ADO Connection Object

8. Main program clogs when adodb.connection object can't make connection

9. DataLink Objects vs Connection Object

10. ADO Command Object using Multiple Connection Objects

11. Command Object vs Connection Object for Row Level Locking

12. Command Object vs Connection Object for Row Level Locking

 

 
Powered by phpBB® Forum Software