Created: (EJBTHREE-889) Up-port SimpleMultiplexer from Branch_4_2

Up-port SimpleMultiplexer from Branch_4_2
-----------------------------------------

                 Key: EJBTHREE-889
                 URL: http:/
/jira.jboss.com/jira/browse/EJBTHREE-889
             Project: EJB 3.0
          Issue Type: Task
            Reporter: Carlo de Wolf
         Assigned To: Carlo de Wolf
             Fix For: EJB 3.0 RC11 - FD




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the
administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atl
assian.com/software/jira

        
_______________________________________________
jboss-jira mailing list
jboss-jiralists.jboss.org
h
ttps://lists.jboss.org/mailman/listinfo/jboss-jira

Hi

I have been using Perl to read/write databases/tables in a
third party 
application using DBD::ODBC and the Visual Foxpro 6 ODBC
driver. 

Everything works OK most of the time but I am running into
problems (documented 
by Microsoft) with the VFP ODBC driver throwing up
connection errors every so 
often. While a browser refresh or two overcomes the problem
this is not really 
satisfactory. The connection string I was using:

$user = "";  $password = "";
$dsno2 = "driver=Microsoft Visual FoxPro 
Driver;SourceDB=C:\OperaII\data\adata\Comp_A.dbc;SourceT
ype=DBC;Exclusive=No
";
unless ($do =
DBI->connect("dbi:ODBC:$dsno2",$user,$password,
{ odbc_cursortype 
=> 2, ChopBlanks => true, LongReadLen => 65536,
LongTruncOk => 0 })) {
   print "Content-type: text/htmlnn";
   print "Error: couldn't connect to Opera II... Error
no:" . $DBI::err . " -
 " . $DBI::errstr . "<br>n";
   exit;
}

I have upgraded the third party application to the latest
version which now 
uses VFP 9, primarily to overcome the known problem with the
ODBC driver. Can 
anyone help with an OLE DB connection string, please?

Any assistance would be greatly appreciated.

Regards
Phil Brewer


----------------------------------------------
This mail sent through http://www.ukonline.net
_______________________________________________
Perl-Win32-Database mailing list
Perl-Win32-Databaselistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs

Copying from http://www.connecti
onstrings.com/ (an excellent resource for such things),
the connection string would follow the pattern of:

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:folder;Extended Properties=dBASE IV;User
ID=Admin;Password=;

Hope this helps

-----Original Message-----
From: perl-win32-database-bounceslistserv.ActiveState.com
[mailto:perl-win32-database-bounceslistserv.ActiveState.com]
On Behalf Of pbrewerukonline.co.uk
Sent: Wednesday, February 21, 2007 3:17 AM
To: perl-win32-databaselistserv.ActiveState.com
Subject: VFP 9 and OLE DB Connection String

Hi

I have been using Perl to read/write databases/tables in a
third party
application using DBD::ODBC and the Visual Foxpro 6 ODBC
driver.

Everything works OK most of the time but I am running into
problems (documented
by Microsoft) with the VFP ODBC driver throwing up
connection errors every so
often. While a browser refresh or two overcomes the problem
this is not really
satisfactory. The connection string I was using:

$user = "";  $password = "";
$dsno2 = "driver=Microsoft Visual FoxPro
Driver;SourceDB=C:\OperaII\data\adata\Comp_A.dbc;SourceT
ype=DBC;Exclusive=No
";
unless ($do =
DBI->connect("dbi:ODBC:$dsno2",$user,$password,
{ odbc_cursortype
=> 2, ChopBlanks => true, LongReadLen => 65536,
LongTruncOk => 0 })) {
   print "Content-type: text/htmlnn";
   print "Error: couldn't connect to Opera II... Error
no:" . $DBI::err . " -
 " . $DBI::errstr . "<br>n";
   exit;
}

I have upgraded the third party application to the latest
version which now
uses VFP 9, primarily to overcome the known problem with the
ODBC driver. Can
anyone help with an OLE DB connection string, please?

Any assistance would be greatly appreciated.

Regards
Phil Brewer


----------------------------------------------
This mail sent through http://www.ukonline.net
_______________________________________________
Perl-Win32-Database mailing list
Perl-Win32-Databaselistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs
_______________________________________________
Perl-Win32-Database mailing list
Perl-Win32-Databaselistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs