Problem opening ADODB.Connection using Win32::OLE 
Author Message
 Problem opening ADODB.Connection using Win32::OLE

I am trying to use ADO to connect to a SQL Server.  The code works
below on servers with MDAC 2.5 installed, but fails on servers with
MDAC 2.1 installed:

my $conn_str    = "Provider=SQLOLEDB;Data Source=$server;Initial
Catalog=AccountRequestRpt;User ID=$user;Password=$passw;";

$Conn = Win32::OLE->new('ADODB.Connection') || return($BAD, "Cannot
create new OLE ADO object: ".Win32::OLE->LastError());

$Conn->Open($conn_str);

The Error opening the connection is:

0 Cannot open OLE ADO object: OLE exception from "ADODB.Connection":

ADO could not find the specified provider.



Tue, 20 Apr 2004 01:40:07 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Opening ADODB.Connection using Win32::OLE without User ID/Password

2. using a perl script to open a word document using WIN32::OLE

3. Problem publishing MS Excel worksheet to HTML using perl Win32::OLE

4. Problems accessing calendar items using Win32::OLE and CDO 1.2.1

5. problems with program using Win32::OLE...

6. Problems using Perl Win32::OLE to control Acrobat Exchange

7. DSNless connection to ADODB Win-32

8. Win32::OLE and Connection Points

9. Win32::OLE connection to a new process?

10. Win32::OLE and Connection Points

11. Win32::OLE Problems: OLE error 0x80010001

12. Opening PPT WIn32:OLE

 

 
Powered by phpBB® Forum Software