MySQL Connection : ODBC

I have an application in VB6 using DataEnvironment object to specify the
connection to a different databases.
Up to now I successfully made connections to a Access, Oracle and SQL Server
databases.
Now I need to make a connection to a MySQL and it return a "Catastrofic
failure" message. I am using the Connect/ODBC 3.51 from MySQL.
Does somebody out there have an idea how can I make it work. What could I b
missing?
Thanks,

"Louis" <Louis@discussions.microsoft.com> wrote in message
news:BE365D2B-9C7A-49CC-B714-F95FCECF0F18@microsoft.com...
> I have an application in VB6 using DataEnvironment object to specify the
> connection to a different databases.
> Up to now I successfully made connections to a Access, Oracle and SQL
Server
> databases.
> Now I need to make a connection to a MySQL and it return a "Catastrofic
> failure" message. I am using the Connect/ODBC 3.51 from MySQL.
> Does somebody out there have an idea how can I make it work. What could I
b
> missing?
> Thanks,

Are you sure your connection string is correct?
http://www.connectionstrings.com/?carrier=mysql

you may need to post some code.

-ralph

Thanks for the link.
When I specify the connection by code I can reach the tables, but cannot
when I tried specifying the provider through the DataEnvironment object.

"Ralph" wrote:

>
> "Louis" <Louis@discussions.microsoft.com> wrote in message
> news:BE365D2B-9C7A-49CC-B714-F95FCECF0F18@microsoft.com...
> > I have an application in VB6 using DataEnvironment object to specify the
> > connection to a different databases.
> > Up to now I successfully made connections to a Access, Oracle and SQL
> Server
> > databases.
> > Now I need to make a connection to a MySQL and it return a "Catastrofic
> > failure" message. I am using the Connect/ODBC 3.51 from MySQL.
> > Does somebody out there have an idea how can I make it work. What could I
> b
> > missing?
> > Thanks,
>
> Are you sure your connection string is correct?
> http://www.connectionstrings.com/?carrier=mysql
>
> you may need to post some code.
>
> -ralph
>
>
>
>
>

"Louis" <Louis@discussions.microsoft.com> wrote in message
news:98C56BA7-E158-49D4-912C-EDFC53A96D45@microsoft.com...
> Thanks for the link.
> When I specify the connection by code I can reach the tables, but cannot
> when I tried specifying the provider through the DataEnvironment object.
>
> "Ralph" wrote:
>
<snipped>

Are you talking about DE Designer?

"Ralph" wrote:

>
> "Louis" <Louis@discussions.microsoft.com> wrote in message
> news:98C56BA7-E158-49D4-912C-EDFC53A96D45@microsoft.com...
> > Thanks for the link.
> > When I specify the connection by code I can reach the tables, but cannot
> > when I tried specifying the provider through the DataEnvironment object.
> >
> > "Ralph" wrote:
> >
> <snipped>
>
> Are you talking about DE Designer?
>
> Yes, You are exactly right!
>

"Louis" <Louis@discussions.microsoft.com> wrote in message
news:0048E152-2CE4-4885-9736-2061ABDDF7DE@microsoft.com...
>
>
> "Ralph" wrote:
>
> >
> > "Louis" <Louis@discussions.microsoft.com> wrote in message
> > news:98C56BA7-E158-49D4-912C-EDFC53A96D45@microsoft.com...
> > > Thanks for the link.
> > > When I specify the connection by code I can reach the tables, but
cannot
> > > when I tried specifying the provider through the DataEnvironment
object.
> > >
> > > "Ralph" wrote:
> > >
> > <snipped>
> >
> > Are you talking about DE Designer?
> >
> > Yes, You are exactly right!
> >

I was afraid of that. <g>

I don't have a MySQL to play with so I can't test the driver myself. There
is likely just a compatibility problem with DE. Duh! <g>

The problem is that DE is so universally despised by so many VB programmers
I'm not sure where you might get help. In fact most might consider that you
are very lucky that it doesn't work, and therefore required to abandon DE!

You might do a quick test to make sure you can connect outside the DE
environment. Use the "VB Data Form Wizard" to create a quick test app. If it
doesn't work, then you need to look elsewhere - perhaps another driver.

It might help to repost your question to
microsoft.public.vb.general.disscussion. (I'm assuming you have checked out
all the MySQL groups and websites?) If you do be sure to include the exact
string you are using.

hth
-ralph