Re: Memory access problem with DBI or DBD-Mysql?

Since there has been no reply to my previous message, I have done further investigations trying to find the problem. Please note that my knowledge of DBI/DBD is almost null, so the followings are only simple suppositions. I have seen that mysql_st_internal_execute() function is executed by

Re: Problem getting Perl - SQL Server connect working - syntax error?

From perldoc DBI: Examples of $data_source values are: dbi:DriverName:database_name dbi:DriverName:[EMAIL PROTECTED]:port dbi:DriverName:database=database_name;host=hostname;port=port You have a colon where you need a semicolon:

Problem getting Perl - SQL Server connect working - syntax error?

OK, someone did point out a syntax error (thanks!), but may have found the glitch...this may sound basic, but I don't know... Do I need to already have created a DSN file somewhere that this Perl code uses? I've been able to go thru the ODBC applet in MS Server and create user, system and file

Oracle and DBI module file

Teammates, How does the DBI module know which tnsnames.ora file (from Oracle) to use ? tanx, Lori Lori (Dolores) Rowe Web Administrator Software Engineering Tools and Environments Boeing (314)882-8784

Re: Problem getting Perl - SQL Server connect working - syntax error?

My bad for just spotting syntax and not thinking about ODBC. Yes, you can create a DSN via the control panel-Administrative Tools-Data Sources (assuming win XP). I've always used System DSN's, rather than file based, but the syntax for a filebased one is in perldoc DBD::ODBC. Actually, reading

Re: Oracle and DBI module file

It reads the $TNS_ADMIN environment variable, or if that is not set, the $ORACLE_HOME in which case it appends the default network/admin to find it. On 8/15/06, Rowe, Dolores A [EMAIL PROTECTED] wrote: Teammates, How does the DBI module know which tnsnames.ora file (from Oracle) to use ?

RE: Problem getting Perl - SQL Server connect working - syntax er ror?

I've successfully connected to a local MS SQL server (MSDE actually) from ActiveState Perl using the following connect string. This is the DSN-less form described in the docs. my $dbh = DBI-connect('DBI:ODBC:Driver={SQL Server};server={(local)};database={my_db};','',''); Since your server is

RE: Oracle and DBI module file

The search directory is the same that SQL*Plus will use. See the Oracle docs for this. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Rowe, Dolores A [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 6:29 AM To: dbi-users@perl.org Subject: Oracle and DBI

Using Oracle Internet Directory (OID) instead of TNS Names

Hi All, Does the current Perl DBI support Oracle Internet Directory? If so, how/where would I go to find out more on how to use this functionality? Thanks. Peter

RE: Using Oracle Internet Directory (OID) instead of TNS Names

If you mean will it use OID to resolve TNS addresses, then yes You don't need to make any changes to the connect string. The DBI will connect to the database just like SQL*Plus will. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL

RE: Using Oracle Internet Directory (OID) instead of TNS Names

Hi Ron, I meant, not using TNS files and instead using Oracle OLAP. Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:54 AM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names If

RE: Using Oracle Internet Directory (OID) instead of TNS Names

That's right. You will need: 1. A sqlnet.ora file which designates the search method: names.directory_path=(LDAP) 2. A ldap.ora file that describes the location of your OID instance: Default_admin_context = dc=xx,dc=yy,dc=com Directory_server=(server.domain.com:non-ssl_port:ssl_port)

RE: Using Oracle Internet Directory (OID) instead of TNS Names

Thanks Ron. You have been most helpful. Look me up when you are in Phoenix. I will buy you lunch. :D Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 1:28 PM To: Loo, Peter # PHX; DBI-Users Subject: RE: Using Oracle Internet

RE: Using Oracle Internet Directory (OID) instead of TNS Names

Hi Ron, We currently have the following configuration. I am assuming that in order for Perl DBI to use OID, LDAP has to be the first in the list? NAMES.DIRECTORY_PATH= (tnsnames, ldap) Peter -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15,

RE: Using Oracle Internet Directory (OID) instead of TNS Names

No. The list is a search order - tnsnames will be checked first, then OID. -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 3:06 PM To: Reidy, Ron; DBI-Users Subject: RE: Using Oracle Internet Directory (OID) instead of TNS Names Hi

Symbol Loading Failure for DBD::Oracle on OSX 10.4.7

I can't get DBD::Oracle past the make test stage. I've read the README.macosx.txt and though there isn't anything directly relevant to OSX 10.4.x, I've tried everything suggested in that file. After a lot of googling and hail mary attempts to get it linked correctly, I'm down to this. (Sorry if

RE: Using Oracle Internet Directory (OID) instead of TNS Names

Hi Ron, According to our *.ora files, everything appears to be set up correctly. However, whenever Perl DBI attempts to connect to an INSTANCE that is not defined in tnsnames.ora file, the Perl program is unable to continue. What we are hoping that Perl DBI would do for us is to perform

RE: Using Oracle Internet Directory (OID) instead of TNS Names

Does SQL*Plus do this correctly from the same machine you are running the Perl scripts? It should work the same because DBD::Oracle uses the OCI to perform it's actions. This means it still uses the O3LOGON functionality. Can you write a simple Perl script that will just connect and disconnect