mysql connection via Powerbuilder

------_=_NextPart_001_01C616A5.862BA520
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C616A5.862BA520"

------_=_NextPart_002_01C616A5.862BA520
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I am using version 3.51.12 of odbc connectr to mysql.

I am using OK my database via phpmyadmin.

My dsn is OK (connection test OK) with the same user/password.

In Powerbuilder, using the data source within a profile, connection =
fails with this error :

In the pbtrace.log, I got the error : Error 999 (rc -1)

Anyone encounted the same problem ?

Pierre Combrisson

Commissariat =E0 l'Energie Atomique

Direction des Sciences de la Mati=E8re (DSM)

D=E9partement de Recherche sur l'Etat Condens=E9, les Atomes et les =
Mol=E9cules (DRECAM).

Adjoint du Chef de D=E9partement

t=E9l : (33) 1 69 08 92 13

gsm : (33) 6 82 56 52 61

------_=_NextPart_002_01C616A5.862BA520
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">

<style>

</style>

</head>

<body lang=3DFR link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hi,<o:p></o:p>

I am using version 3.51.12 of odbc connectr to =
mysql.<o:p></o:p>

I am using OK my database via =
phpmyadmin.<o:p></o:p>

My dsn is OK (connection test OK) with the =
same
user/password.<o:p></o:p>

In Powerbuilder, using the data source within =
a
profile, connection fails with this error :<o:p></o:p>

<img width=3D306 height=3D134 =
id=3D"_x0000_i1025"
src=3D"cid:image002.jpg [at] 01C616AD.E7E7A8B0"><o:p></o:p>

In the pbtrace.log, I got the error : Error =
999 (rc
-1)<o:p></o:p>

<o:p> </o:p>

Anyone encounted the same problem =
?<o:p></o:p>

<o:p> </o:p>

<div style=3D'mso-element:para-border-div;border:none;border-top:solid =
windowtext 1.0pt;
padding:1.0pt 0cm 0cm 0cm'>

Pierre =
Combrisson<o:p></o:p>

</div>

Commissariat =E0 l'Energie =
Atomique<o:p></o:p>

Direction des Sciences de la Mati=E8re =
(DSM)<o:p></o:p>

D=E9partement de Recherche sur l'Etat Condens=E9, les =
Atomes et
les Mol=E9cules (DRECAM).<o:p></o:p>

Adjoint du Chef de =
D=E9partement<o:p></o:p>

t=E9l : (33) 1 69 08 92 =
13<o:p></o:p>

gsm : (33) 6 82 56 52 61<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_002_01C616A5.862BA520--

------_=_NextPart_001_01C616A5.862BA520--

COMBRISSON Pierre [ Mi, 11 Januar 2006 12:52 ] [ ID #1136993 ]

RE: mysql connection via Powerbuilder

Hi Pierre

The screenshot you've attached inline in your message is
gone from the message at the time when I, and probably other
list members, receive your message.

From the looks of things, the screenshot should've been sitting
in a MIME part in your message which seems to have been completely
removed. Since you're using Outlook to post messages, I don't
imagine that you've stripped it yourself. More likely, it's been
removed by either your outgoing e-mail gateway or, perhaps more
likely, by the qmail/ezmlm software that runs the MyODBC list.

Perhaps you can provide a textual description of your problem?
Or upload the image somewhere so we can see it..

Alternatively, you should be able to get in touch with the myodbc
list owner by mailing to myodbc-owner [at] lists.mysql.com, perhaps
(s)he knows what's going on..

HTH
/David

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

David Dindorp [ Mi, 11 Januar 2006 13:35 ] [ ID #1136995 ]

RE: mysql connection via Powerbuilder

COMBRISSON Pierre wrote:
> The error message I get back is :
> In Powerbuilder : Y000 User cancelled

Looks odd. MyODBC error messages are usually HYxxx, not Yxxx.

> In Excel : User cancelled.
> In the dsn box, the testing is OK.

I have no experience with PowerBuilder, I just wanted to
give you a heads-up on the missing image in your posting ;-).

I've searched the archives for you, though. It seems that
other users have had a similar issue to what you're seeing.

MyODBC mailing list archive:
http://lists.mysql.com/search.php?q=3Duser+cancelled&list=3D myodbc&m=3Da&=
begin
=3D-1

MyODBC forum archive:
http://forums.mysql.com/search.php?0,search=3DHY000+user+can celled,page=3D=
1,
match_type=3DALL,match_dates=3D0,match_forum=3DALL,body=3D1, author=3D1,su=
bject=3D1

Here's one with a similar problem:
http://forums.mysql.com/read.php?37,50649,50649#msg-50649

The solution for him was to downgrade MyODBC:
http://forums.mysql.com/read.php?37,50649,50770

The MyODBC lead developer suggested upgrading to an
unofficial new version from a secret FTP:
http://forums.mysql.com/read.php?37,50649,53792#msg-53792

HTH
/David

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

David Dindorp [ Mi, 11 Januar 2006 14:04 ] [ ID #1136996 ]