Greetings,

Desperately trying to get ODBC running from a web server to a remote =
MySQL
database. However, whether using system or user DSN and/or =
connectionless
DSN from ASP I generally get down to:
Error Type:
Provider (0x8000FFFF)
Catastrophic failure

Here is the code snippet:
set my_conn =3D Server.CreateObject("ADODB.Connection")
Set rs =3D Server.CreateObject("ADODB.Recordset")
my_conn.Open "DSN=3Dmysql_dsn" ' Data source name

Any ideas?

Dain A. Müller
VP & Technical Officer
Community WISP, Inc.
(p) 781-863-1035
(f) 781-658-2087
Authorized Canopy Solutions Provider
Member Better Business Bureau
South Shore Chamber of Commerce



--
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

Hi,

I don't know what could cause the error, but I would try a full connectio=
n string, and see if it will work:

DRIVER=3D{MySQL ODBC 3.51 Driver};DESC=3D;DB=3D<db_name>;SERVER=3D<server=
_ip_or_name>;UID=3D<db_user>;PASSWORD=3D<db_password>;PORT=3D3306;SOCKET=3D=
;OPTION=3D2050;STMT=3D;

OPTION is set to work with MS Access linked tables. I use it in ADO conne=
ctions with MyODBC 3.51.10, and it works fine.

> -----Original Message-----
> From: Dain Muller [mailto:dmuller [at] communitywisp.com]
> Sent: Wednesday, January 19, 2005 12:05 PM
> To: myodbc [at] lists.mysql.com
> Subject: ODBC Errors
>
>
> Greetings,
>
> Desperately trying to get ODBC running from a web server to a
> remote MySQL
> database. However, whether using system or user DSN and/or
> connectionless
> DSN from ASP I generally get down to:
> Error Type:
> Provider (0x8000FFFF)
> Catastrophic failure
>
> Here is the code snippet:
> set my_conn =3D Server.CreateObject("ADODB.Connection")
> Set rs =3D Server.CreateObject("ADODB.Recordset")
> my_conn.Open "DSN=3Dmysql_dsn" ' Data source name
>
> Any ideas?
>
> Dain A. Müller
> VP & Technical Officer
> Community WISP, Inc.
> (p) 781-863-1035
> (f) 781-658-2087
> Authorized Canopy Solutions Provider
> Member Better Business Bureau
> South Shore Chamber of Commerce
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Dartem.koltsov [at] wfinet.c om

=A0
Attention:
Any views expressed in this message are those of the individual sender, e=
xcept where the message states otherwise and the sender is authorized to =
state them to be the views of any such entity. The information contained =
in this message and or attachments is intended only for the person or ent=
ity to which it is addressed and may contain confidential and/or privileg=
ed material. If you received this in error, please contact the sender an=
d delete the material from any system and destroy any copies.

--
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

Nope, still get it:
Provider (0x8000FFFF)
Catastrophic failure

Set my_conn =3D Server.CreateObject("ADODB.Connection")
Set rs =3D Server.CreateObject("ADODB.Recordset")
my_conn.Open("DRIVER=3D{MySQL ODBC 3.51
Driver};DESC=3D;DB=3D0404SSE;SERVER=3D192.168.1.3;UID=3Ddmul ler;PASSWORD=3D=
password;PO
RT=3D3306;SOCKET=3D;OPTION=3D2050;STMT=3D;")

now, if I look at the local machine and give it a bogus account, I get a
wrong username and password error, but if I give it a real account, it =
gives
me the same error. So, this is obviously something in the way it is =
opening
the connection.

Dain A. Müller
VP & Technical Officer
Community WISP, Inc.
(p) 781-863-1035
(f) 781-658-2087
Authorized Canopy Solutions Provider
Member Better Business Bureau
South Shore Chamber of Commerce

-----Original Message-----
From: Artem Koltsov [mailto:Artem.Koltsov [at] wfinet.com]
Sent: Wednesday, January 19, 2005 12:26 PM
To: myodbc [at] lists.mysql.com
Subject: RE: ODBC Errors

Hi,

I don't know what could cause the error, but I would try a full =
connection
string, and see if it will work:

DRIVER=3D{MySQL ODBC 3.51
Driver};DESC=3D;DB=3D<db_name>;SERVER=3D<server_ip_or_name>;UID=3D<db_use=
r>;PASSWORD
=3D<db_password>;PORT=3D3306;SOCKET=3D;OPTION=3D2050;STMT=3D;

OPTION is set to work with MS Access linked tables. I use it in ADO
connections with MyODBC 3.51.10, and it works fine.

> -----Original Message-----
> From: Dain Muller [mailto:dmuller [at] communitywisp.com]
> Sent: Wednesday, January 19, 2005 12:05 PM
> To: myodbc [at] lists.mysql.com
> Subject: ODBC Errors
>
>
> Greetings,
>
> Desperately trying to get ODBC running from a web server to a
> remote MySQL
> database. However, whether using system or user DSN and/or
> connectionless
> DSN from ASP I generally get down to:
> Error Type:
> Provider (0x8000FFFF)
> Catastrophic failure
>
> Here is the code snippet:
> set my_conn =3D Server.CreateObject("ADODB.Connection")
> Set rs =3D Server.CreateObject("ADODB.Recordset")
> my_conn.Open "DSN=3Dmysql_dsn" ' Data source name
>
> Any ideas?
>
> Dain A. Müller
> VP & Technical Officer
> Community WISP, Inc.
> (p) 781-863-1035
> (f) 781-658-2087
> Authorized Canopy Solutions Provider
> Member Better Business Bureau
> South Shore Chamber of Commerce
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Dartem.koltsov [at] wfinet.c om

=A0
Attention:
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized =
to
state them to be the views of any such entity. The information contained =
in
this message and or attachments is intended only for the person or =
entity to
which it is addressed and may contain confidential and/or privileged
material. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Ddmuller [at] communitywisp. com




--
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

Check this link out http://support.microsoft.com/kb/q243349/

Maybe you need update MDAC to fix it?

> -----Original Message-----
> From: Dain Muller [mailto:dmuller [at] communitywisp.com]
> Sent: Wednesday, January 19, 2005 1:25 PM
> To: myodbc [at] lists.mysql.com
> Subject: RE: ODBC Errors
>
>
> Nope, still get it:
> Provider (0x8000FFFF)
> Catastrophic failure
>
> Set my_conn =3D Server.CreateObject("ADODB.Connection")
> Set rs =3D Server.CreateObject("ADODB.Recordset")
> my_conn.Open("DRIVER=3D{MySQL ODBC 3.51
> Driver};DESC=3D;DB=3D0404SSE;SERVER=3D192.168.1.3;UID=3Ddmul ler;PASSWO
> RD=3Dpassword;PO
> RT=3D3306;SOCKET=3D;OPTION=3D2050;STMT=3D;")
>
> now, if I look at the local machine and give it a bogus
> account, I get a
> wrong username and password error, but if I give it a real
> account, it gives
> me the same error. So, this is obviously something in the way
> it is opening
> the connection.
>
> Dain A. Müller
> VP & Technical Officer
> Community WISP, Inc.
> (p) 781-863-1035
> (f) 781-658-2087
> Authorized Canopy Solutions Provider
> Member Better Business Bureau
> South Shore Chamber of Commerce
>
> -----Original Message-----
> From: Artem Koltsov [mailto:Artem.Koltsov [at] wfinet.com]
> Sent: Wednesday, January 19, 2005 12:26 PM
> To: myodbc [at] lists.mysql.com
> Subject: RE: ODBC Errors
>
> Hi,
>
> I don't know what could cause the error, but I would try a
> full connection
> string, and see if it will work:
>
> DRIVER=3D{MySQL ODBC 3.51
> Driver};DESC=3D;DB=3D<db_name>;SERVER=3D<server_ip_or_name>;UID=3D<db_
> user>;PASSWORD
> =3D<db_password>;PORT=3D3306;SOCKET=3D;OPTION=3D2050;STMT=3D;
>
> OPTION is set to work with MS Access linked tables. I use it in ADO
> connections with MyODBC 3.51.10, and it works fine.
>
> > -----Original Message-----
> > From: Dain Muller [mailto:dmuller [at] communitywisp.com]
> > Sent: Wednesday, January 19, 2005 12:05 PM
> > To: myodbc [at] lists.mysql.com
> > Subject: ODBC Errors
> >
> >
> > Greetings,
> >
> > Desperately trying to get ODBC running from a web server to a
> > remote MySQL
> > database. However, whether using system or user DSN and/or
> > connectionless
> > DSN from ASP I generally get down to:
> > Error Type:
> > Provider (0x8000FFFF)
> > Catastrophic failure
> >
> > Here is the code snippet:
> > set my_conn =3D Server.CreateObject("ADODB.Connection")
> > Set rs =3D Server.CreateObject("ADODB.Recordset")
> > my_conn.Open "DSN=3Dmysql_dsn" ' Data source name
> >
> > Any ideas?
> >
> > Dain A. Müller
> > VP & Technical Officer
> > Community WISP, Inc.
> > (p) 781-863-1035
> > (f) 781-658-2087
> > Authorized Canopy Solutions Provider
> > Member Better Business Bureau
> > South Shore Chamber of Commerce
> >
> >
> >
> > --
> > MySQL ODBC Mailing List
> > For list archives: http://lists.mysql.com/myodbc
> > To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=3Dartem.koltsov [at] wfinet.c om
>
> =A0
> Attention:
> Any views expressed in this message are those of the
> individual sender,
> except where the message states otherwise and the sender is
> authorized to
> state them to be the views of any such entity. The
> information contained in
> this message and or attachments is intended only for the
> person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. If you received this in error, please contact the
> sender and
> delete the material from any system and destroy any copies.
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=3Ddmuller [at] communitywisp. com
>
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Dartem.koltsov [at] wfinet.c om

=A0
Attention:
Any views expressed in this message are those of the individual sender, e=
xcept where the message states otherwise and the sender is authorized to =
state them to be the views of any such entity. The information contained =
in this message and or attachments is intended only for the person or ent=
ity to which it is addressed and may contain confidential and/or privileg=
ed material. If you received this in error, please contact the sender an=
d delete the material from any system and destroy any copies.

--
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

And, check if MySQL has properly setup user for the remote access, something
like user [at] remote_machine_IP


----- Original Message -----
From: "Artem Koltsov" <Artem.Koltsov [at] wfinet.com>
To: <myodbc [at] lists.mysql.com>
Sent: Wednesday, January 19, 2005 12:26 PM
Subject: RE: ODBC Errors


Hi,

I don't know what could cause the error, but I would try a full connection
string, and see if it will work:

DRIVER={MySQL ODBC 3.51
Driver};DESC=;DB=<db_name>;SERVER=<server_ip_or_name>;UID=<db_user>;PASSWORD
=<db_password>;PORT=3306;SOCKET=;OPTION 50;STMT=;

OPTION is set to work with MS Access linked tables. I use it in ADO
connections with MyODBC 3.51.10, and it works fine.

> -----Original Message-----
> From: Dain Muller [mailto:dmuller [at] communitywisp.com]
> Sent: Wednesday, January 19, 2005 12:05 PM
> To: myodbc [at] lists.mysql.com
> Subject: ODBC Errors
>
>
> Greetings,
>
> Desperately trying to get ODBC running from a web server to a
> remote MySQL
> database. However, whether using system or user DSN and/or
> connectionless
> DSN from ASP I generally get down to:
> Error Type:
> Provider (0x8000FFFF)
> Catastrophic failure
>
> Here is the code snippet:
> set my_conn = Server.CreateObject("ADODB.Connection")
> Set rs = Server.CreateObject("ADODB.Recordset")
> my_conn.Open "DSN=mysql_dsn" ' Data source name
>
> Any ideas?
>
> Dain A. Müller
> VP & Technical Officer
> Community WISP, Inc.
> (p) 781-863-1035
> (f) 781-658-2087
> Authorized Canopy Solutions Provider
> Member Better Business Bureau
> South Shore Chamber of Commerce
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
http://lists.mysql.com/myodbc?unsub=artem.koltsov [at] wfinet.com


Attention:
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity. The information contained in
this message and or attachments is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mberman [at] ivesinc.com




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

Dain,

Currently working in an issue with SQLDriverConnect. Seems that there is
some inconsistency across MDAC versions where some people have problems
and others do not.

Will publish a fix on www.mysql.com soon.

Dain Muller wrote:

>Greetings,
>
>Desperately trying to get ODBC running from a web server to a remote MySQL
>database. However, whether using system or user DSN and/or connectionless
>DSN from ASP I generally get down to:
>Error Type:
>Provider (0x8000FFFF)
>Catastrophic failure
>
>Here is the code snippet:
>set my_conn = Server.CreateObject("ADODB.Connection")
>Set rs = Server.CreateObject("ADODB.Recordset")
>my_conn.Open "DSN=mysql_dsn" ' Data source name
>
>Any ideas?
>
>Dain A. Müller
>VP & Technical Officer
>Community WISP, Inc.
>(p) 781-863-1035
>(f) 781-658-2087
>Authorized Canopy Solutions Provider
>Member Better Business Bureau
>South Shore Chamber of Commerce
>
>
>
>
>


--
Peter Harvey, Software Developer
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



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