Thanks Shawn,
The guy with MySQL went home already, I am using Firebird for testing
(or learning to use) databases, and got something working with Firebird
and ODBC (not perfectly, but something is more than nothing). The other
guy (student doing internship, I am his tutor ) is trying to use
MySQL, because it is more known. I will forward this to him, and let him
fight his battle alone...
I am starting to suspect his firewall has something to do with this, was
trying to help him out today and couldnt even ping his laptop.... (what
do you think about this?)
http://www.connectionstrings.com worked for me and Firebird, already had it bookmarked, but I will check the other link.
Thanks again.
Nelson
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
The guy with MySQL went home already, I am using Firebird for testing
(or learning to use) databases, and got something working with Firebird
and ODBC (not perfectly, but something is more than nothing). The other
guy (student doing internship, I am his tutor ) is trying to use
MySQL, because it is more known. I will forward this to him, and let him
fight his battle alone...
I am starting to suspect his firewall has something to do with this, was
trying to help him out today and couldnt even ping his laptop.... (what
do you think about this?)
http://www.connectionstrings.com worked for me and Firebird, already had it bookmarked, but I will check the other link.
Thanks again.
Nelson
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Well, it all looks good to me, but I haven't used MyODBC with VEE. The
Archive uses it, but one side is through a php script and the other side is
through VB. I have a System DSN set up for the Archive DB. VB connects to
the database like so:
Call cn.Open("Provider=MSDASQL.1;Persist Security Info=False;User
ID=vrf_user;Data Source=" + sSource)
where sSource is "VRF Archive", the name of the System DSN record. When I
try your attached program I get "Access denied for user 'root'@'localhost'
(using password: NO)", which looks to me like the MySQL user password mysql
is not being transmitted. Just for reference, in my case the password comes
from the DSN, not anything in VB.
-SHAWN-
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".