DBI for Adabas and Tamino
Hello out there, I just want to ask if there is any solution for Adabas or Tamino and DBI? As it seems, there is no driver for these systems available? Gruss Christian -- "Feel free" mit GMX FreeMail! Monat für Monat 10 FreeSMS inklusive! http://www.gmx.net
Re: DBI for Adabas and Tamino
http://www.google.com/search?q=DBD::Adabas returns the CPAN page for DBD::Adabas as *FIRST* result http://www.google.com/search?q=DBD::Tamino has only one result, stating that there seems to be non DBD::Tamino http://search.cpan.org/search?query=Tamino&mode=all returns XML::EP, that's not a DBI driver. Time: 10 seconds, faster than posting a message to dbi-users. Alexander Christian Stalp wrote: Hello out there, I just want to ask if there is any solution for Adabas or Tamino and DBI? As it seems, there is no driver for these systems available? Gruss Christian -- Alexander Foken mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
Re: DBI for Adabas and Tamino
> http://www.google.com/search?q=DBD::Adabas returns the CPAN page for > DBD::Adabas as *FIRST* result Ok Im blind ;-) > http://www.google.com/search?q=DBD::Tamino has only one result, stating > that there seems to be non DBD::Tamino But this leads to an empty page! > http://search.cpan.org/search?query=Tamino&mode=all returns XML::EP, > that's not a DBI driver. > > Time: 10 seconds, faster than posting a message to dbi-users. > > Alexander > -- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl
Re: Using Kerberos enabled connections with Sybase
On 2/23/06, Chuck Fox <[EMAIL PROTECTED]> wrote: > > Hello fellow dbi-users. > > I am attempting to connect to a 12.5 Sybase server using kerberos > enabled connections. My isql and sqsh both correctly connect (sqsh > needed a small fix to load the security ). However, I am unable to get > DBD::Sybase to load the security modules. It appears that you have to pass the syb_kerberos_serverprincipal > through the attributes as opposed to using the DSN. Should the check be > against kerberosPrincipal instead of kerbGetTicket ? The syb_kerberos_serverprincipal is a reference to a subroutine that fetches the principal. It was coded so that you could have a parametrized way of retrieving the principal. That being said there are other problems with loading the Kerberos libs and DBD::Sybase that I'm looking into at the moment. Michael
Re: Can't connect to Sybase Rep server
On 2/28/06, Matthew Persico <[EMAIL PROTECTED]> wrote: > > Message d'origine > > De: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Date: mar. 28.02.2006 07:54 > > À: [EMAIL PROTECTED] > > Cc: dbi-users@perl.org > > Objet: Re: Can't connect to Sybase Rep server > > > > > > > > This is a known problem, and has been fixed in either 1.07 or > > 1.07_01. > > Must be 1.07_01 'cause I am running 1.07. I will download and try it. > is the _01 designation ok for production use? Better yet, can anyone point me to where 1.07_01 lives? It's not on CPAN. > > And by the way, I hopefully fixed the email chaining - someone grabbed > the thread for a completely unrelated question. > > > > > DBD::Sybase tries to see if chained transactions are supported > > at startup, > > and tries to find the @@version of the server. Both of these > > requests fail > > against a replication server, but the failure is expected, so > > should simply > > be hidden from the user... > > > > Michael > > > [EMAIL PROTECTED] - 27/02/2006 20:39 > > > > To:dbi-users, Michael PEPPLER > > > > cc: > > > > > > Subject:Can't connect to Sybase Rep server > > > > > > This simple test program: > > > > use strict; > > use warnings; > > use DBI; > > my $dbh = DBI->connect('dbi:Sybase:server=REPP', 'REPP_login', > > 'REPP_passwd', {RaiseError => 1}); > > my $dummy = 6; > > > > causes this: > > > > Server message number=17001 severity=10 state=0 line=0 > > server=REPP > > text=No SRV_OPTION handler installed.OpenClient message: LAYER = > > (1) > > ORIGIN = (1) SEVERITY = (1) NUMBER = (183) > > Server REPP, database > > Message String: ct_options(): user api layer: external error: An > > error > > was returned from the server while setting the options, check > > the > > server message for details. > > Server message number=2056 severity=12 state=0 line=0 > > server=REPP > > text=Line 1, character 8: Incorrect syntax with 'select'. > > [EMAIL PROTECTED] (DEV, uid=8030(persicom) gid=200(develop) > > depth=0) > > > > using Perl 5.6.1, DBI 1.48 and DBD::Sybase 1.07. > > > > However, when using Perl 5.6.1, DBI 1.37 and DBD::Sybase 1.00, I > > get > > no error message. > > > > What DBI trace flags/envars do I neet to set in order to > > diagnose this? > > > > -- > > Matthew O. Persico > > > -- Matthew O. Persico
Re: Can't connect to Sybase Rep server
On 3/1/06, Matthew Persico <[EMAIL PROTECTED]> wrote: > On 2/28/06, Matthew Persico <[EMAIL PROTECTED]> wrote: > > > Message d'origine > > > De: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > > Date: mar. 28.02.2006 07:54 > > > À: [EMAIL PROTECTED] > > > Cc: dbi-users@perl.org > > > Objet: Re: Can't connect to Sybase Rep server > > > > > > > > > > > > This is a known problem, and has been fixed in either 1.07 or > > > 1.07_01. > > > > Must be 1.07_01 'cause I am running 1.07. I will download and try it. > > is the _01 designation ok for production use? > > Better yet, can anyone point me to where 1.07_01 lives? It's not on CPAN. Never mind: http://www.peppler.org/downloads/ > > > > > And by the way, I hopefully fixed the email chaining - someone grabbed > > the thread for a completely unrelated question. > > > > > > > > DBD::Sybase tries to see if chained transactions are supported > > > at startup, > > > and tries to find the @@version of the server. Both of these > > > requests fail > > > against a replication server, but the failure is expected, so > > > should simply > > > be hidden from the user... > > > > > > Michael > > > > > [EMAIL PROTECTED] - 27/02/2006 20:39 > > > > > > To:dbi-users, Michael PEPPLER > > > > > > cc: > > > > > > > > > Subject:Can't connect to Sybase Rep server > > > > > > > > > This simple test program: > > > > > > use strict; > > > use warnings; > > > use DBI; > > > my $dbh = DBI->connect('dbi:Sybase:server=REPP', 'REPP_login', > > > 'REPP_passwd', {RaiseError => 1}); > > > my $dummy = 6; > > > > > > causes this: > > > > > > Server message number=17001 severity=10 state=0 line=0 > > > server=REPP > > > text=No SRV_OPTION handler installed.OpenClient message: LAYER = > > > (1) > > > ORIGIN = (1) SEVERITY = (1) NUMBER = (183) > > > Server REPP, database > > > Message String: ct_options(): user api layer: external error: An > > > error > > > was returned from the server while setting the options, check > > > the > > > server message for details. > > > Server message number=2056 severity=12 state=0 line=0 > > > server=REPP > > > text=Line 1, character 8: Incorrect syntax with 'select'. > > > [EMAIL PROTECTED] (DEV, uid=8030(persicom) gid=200(develop) > > > depth=0) > > > > > > using Perl 5.6.1, DBI 1.48 and DBD::Sybase 1.07. > > > > > > However, when using Perl 5.6.1, DBI 1.37 and DBD::Sybase 1.00, I > > > get > > > no error message. > > > > > > What DBI trace flags/envars do I neet to set in order to > > > diagnose this? > > > > > > -- > > > Matthew O. Persico > > > > > > > > -- > Matthew O. Persico > -- Matthew O. Persico
Re: Can't connect to Sybase Rep server
One solution would be to install your own error handler and catch the 17001 and 2056 errors and ignore them. HTH, Chuck [EMAIL PROTECTED] wrote: This is not a very helpful answer, but are you sure this is worth trying? A Replication Server is not an Adaptive Server Enterprise. Admittedly they both use the same Tabular Data Stream networking protocol, but they have very different command languages. A Rep Server isn't even a database server. Are you sure it is reasonable to expect a DBI driver for Sybase ASE to work correctly with Rep Server? Maybe Sybperl is the way to go if you want your perl program to talk to a Rep Server. Good luck, Mark Matthew Persico wrote: This simple test program: use strict; use warnings; use DBI; my $dbh = DBI->connect('dbi:Sybase:server=REPP', 'REPP_login', 'REPP_passwd', {RaiseError => 1}); my $dummy = 6; causes this: Server message number=17001 severity=10 state=0 line=0 server=REPP text=No SRV_OPTION handler installed.OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (183) Server REPP, database Message String: ct_options(): user api layer: external error: An error was returned from the server while setting the options, check the server message for details. Server message number=2056 severity=12 state=0 line=0 server=REPP text=Line 1, character 8: Incorrect syntax with 'select'. [EMAIL PROTECTED] (DEV, uid=8030(persicom) gid=200(develop) depth=0) using Perl 5.6.1, DBI 1.48 and DBD::Sybase 1.07. However, when using Perl 5.6.1, DBI 1.37 and DBD::Sybase 1.00, I get no error message. What DBI trace flags/envars do I neet to set in order to diagnose this? -- Matthew O. Persico
Re: Can't connect to Sybase Rep server
On 3/1/06, Chuck Fox <[EMAIL PROTECTED]> wrote: > One solution would be to install your own error handler and catch the > 17001 and 2056 errors and ignore them. I am hesitant to do this. I prefer to install error handlers to catch errors that I know I am causing. However, the select that is causing this problem in inside DBD::Sybase, during the connection phase. If the protocol changes in a newer version of DBD::Sybase, these errors could become legit and I wouldn't know. Better to fix at the point of error; in this case, inside DBD::Sybase. > > HTH, > > Chuck > > [EMAIL PROTECTED] wrote: > > > This is not a very helpful answer, but are you sure this is worth > > trying? A Replication Server is not an Adaptive Server Enterprise. > > Admittedly they both use the same Tabular Data Stream networking > > protocol, but they have very different command languages. A Rep > > Server isn't even a database server. Are you sure it is reasonable to > > expect a DBI driver for Sybase ASE to work correctly with Rep Server? > > > > Maybe Sybperl is the way to go if you want your perl program to talk > > to a Rep Server. > > > > Good luck, > > > > Mark > > > > Matthew Persico wrote: > > > >> This simple test program: > >> > >> use strict; > >> use warnings; > >> use DBI; > >> my $dbh = DBI->connect('dbi:Sybase:server=REPP', 'REPP_login', > >> 'REPP_passwd', {RaiseError => 1}); > >> my $dummy = 6; > >> > >> causes this: > >> > >> Server message number=17001 severity=10 state=0 line=0 server=REPP > >> text=No SRV_OPTION handler installed.OpenClient message: LAYER = (1) > >> ORIGIN = (1) SEVERITY = (1) NUMBER = (183) > >> Server REPP, database > >> Message String: ct_options(): user api layer: external error: An error > >> was returned from the server while setting the options, check the > >> server message for details. > >> Server message number=2056 severity=12 state=0 line=0 server=REPP > >> text=Line 1, character 8: Incorrect syntax with 'select'. > >> [EMAIL PROTECTED] (DEV, uid=8030(persicom) gid=200(develop) depth=0) > >> > >> using Perl 5.6.1, DBI 1.48 and DBD::Sybase 1.07. > >> > >> However, when using Perl 5.6.1, DBI 1.37 and DBD::Sybase 1.00, I get > >> no error message. > >> > >> What DBI trace flags/envars do I neet to set in order to diagnose this? > >> > >> -- > >> Matthew O. Persico > >> > >> > >> > >> > > > -- Matthew O. Persico
Re: Can't connect to Sybase Rep server
Edited for brevity On 3/1/06, Matthew Persico <[EMAIL PROTECTED]> wrote: > On 3/1/06, Matthew Persico <[EMAIL PROTECTED]> wrote: > > On 2/28/06, Matthew Persico <[EMAIL PROTECTED]> wrote: > > > > Message d'origine > > > > De: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED] > > > > Date: mar. 28.02.2006 07:54 > > > > À: [EMAIL PROTECTED] > > > > Cc: dbi-users@perl.org > > > > Objet: Re: Can't connect to Sybase Rep server > > > > > > > > > > > > > > > > This is a known problem, and has been fixed in either 1.07 or > > > > 1.07_01. > > > > > > Must be 1.07_01 'cause I am running 1.07. I will download and try it. > > > is the _01 designation ok for production use? > > > > Better yet, can anyone point me to where 1.07_01 lives? It's not on CPAN. > > Never mind: > > http://www.peppler.org/downloads/ > I did a diff on 1.07 vs 1.07_01 and I didn't notice any differences that would indicate this problem being solved. I also diffed 1.00 vs 1.07_01 and didn't notice any differences that would indicate this problem being solved. What should I be looking for?
RE: A common perl script for different database platforms
It worked with "use DBI". Thanks all for the input, appreciate it -Original Message- From: Clive Eisen [mailto:[EMAIL PROTECTED] Sent: Monday, February 27, 2006 5:32 PM To: Hetal Soni Cc: dbi-users@perl.org Subject: Re: A common perl script for different database platforms Hetal Soni wrote: > > > Thanks for your input guys. > > I removed both "use:DBD::Oralce" and "use"DBD:DB2" lines and now > getting following error: > > Can't locate object method "connect" via package "DBI" (perhaps you > forgot to lo ad "DBI"?) at tmp1.plx line 58. > > you do have use DBI; in your program? NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies and attachments of the original message.