CDBIL::Relationship

2008-03-13 Thread gswitkow
Hi All Hope it's good place to put some problem with CDBIL::Relationship Help me please to understand rules of writing relationships. For example: i've got two simple, testing DB (PostgreSQL): test_fk test_pk test_fk_id (PK) test_pk (PK) - test_pk (FK) and I

perl DBI on windows 64

2008-03-13 Thread Ramakrishna Raju
Hi, I am trying to connect to SQL Server 2005 on a windows 64bit machine from the same machine. And I get this error message: DBI connect(xxxsql01,'sa',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) at a.pl

Re: perl DBI on windows 64

2008-03-13 Thread Alexander Foken
It seems you don't have a valid ODBC data source named xxxsql01. If you are running your script from a web server, it has to be a system data source, else it may also be a user data source. And by the way: Are you sure you want to connect as sa? That account usually has too many privileges.

Re: perl DBI on windows 64

2008-03-13 Thread Martin Evans
Ramakrishna Raju wrote: Hi, I am trying to connect to SQL Server 2005 on a windows 64bit machine from the same machine. And I get this error message: DBI connect(xxxsql01,'sa',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver

RE: perl DBI on windows 64

2008-03-13 Thread Ramakrishna Raju
I created a system DSN, and the 'sa' login is just to get things right, so I don't run into permission issues. Eventually I will use the appropriate login. Thanks for the concern. Ramakrishna Raju ( Raju ) [EMAIL PROTECTED] -Original Message- From: Alexander Foken

RE: perl DBI on windows 64

2008-03-13 Thread Ramakrishna Raju
I applied the latest DBD-ODBC 1.15 version (Martin J Evans) and it still is a problem. Is there any fix or work around for this issue? Appreciate your time, Thanks, Ramakrishna Raju ( Raju ) [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Are you

Re: perl DBI on windows 64

2008-03-13 Thread Martin Evans
Sorry for the mess of replying but for some reason my email client won't include your text when it was added after my signature. There are 2 odbc administrators - one you get to in the normal way through control panel, administrative tools, data sources (the 64 bit one) and one you have to go

RE: perl DBI on windows 64

2008-03-13 Thread Ramakrishna Raju
Martin, Great !! That works. I am so happy now. I went thru so much frustration I almost abandoned the Perl approach. Thanks, Martin. And now, I am looking for a web link or a short snippet that does robust error handling of SQL errors. And how to process the output of sql print

Re: DBD::Oracle - execute_array core dumps intermittently [SOLVED]

2008-03-13 Thread Scott T. Hildreth
On Fri, 2008-03-07 at 16:36 -0600, Scott T. Hildreth wrote: This seems to be a threading error with the linux kernel version. I am running this process on newer kernels (2.6.22.x) and the error never occurs. We also are experiencing a lot the Futex WAIT issues with Oracle and the 2.6.20

Re: perl DBI on windows 64

2008-03-13 Thread Alexander Foken
On 13.03.2008 19:49, Ramakrishna Raju wrote: And now, I am looking for a web link or a short snippet that does robust error handling of SQL errors. Use the RaiseError DBI attribute, preferably during connect(). And how to process the output of sql print statements. SQL does not

RE: perl DBI on windows 64

2008-03-13 Thread Ramakrishna Raju
Alexander, t-SQL has a print command and lot of stored procs have print statements in the code to indicate progress of execution or whatever. I need to capture it and print that to my log. In the error handling department, if there is duplicate key error on a insert or a table