Re: MDAC question
From: Griff (Howling_at_The.Moon)
Date: 01/04/05
- Next message: Paul Clement: "Re: Connecting visual basic 5.0 to access 2003"
- Previous message: Ralph: "Re: Connecting visual basic 5.0 to access 2003"
- In reply to: Ralph: "Re: MDAC question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 Jan 2005 17:32:13 -0000
> First of all you are missing a major part of the question - what versions
of
> the ADO Data library are your applications using?
Checked the ADO version by creating an ADODB.Connection object and checking
the reported VERSION property.
The application tier is running ADO 2.7
The data tier is running ADO 2.8.
> What provider/driver version are you using?
The provider is SQLOLEDB:
obConnection.Open "Provider=SQLOLEDB;Persist Security Info=False;" &
"Server=" & sConnectionServer & ";Initial Catalog=" & sDatabaseName,
sConnectionUsername, sConnectionPassword
I don't know what driver version this is.... Should I be using
"Provider=SQLOLEDB.1" ?
Just to confirm, this is a VB6 application, not .NET.
Griff
- Next message: Paul Clement: "Re: Connecting visual basic 5.0 to access 2003"
- Previous message: Ralph: "Re: Connecting visual basic 5.0 to access 2003"
- In reply to: Ralph: "Re: MDAC question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
