Hi all!

I had posted this as a followup to a different question, but for future reference of those having trouble I decided to repost it under a better topic header.

My problem is this:

DIM cn as ADODB.connection
DIM rs as ADODB.recordset
DIM SQLString as String
SQLString = "INSERT INTO table_name (Blah, blah, blah) VALUES (yadda, yadda, yadda)"
cn = set new ADODB.conn.... etc
etc
etc

And everything's fine until I hit this part of the program:


cn.Open "Driver={MySQL ODBC 3.51 Driver};Server=www.oursqldomain.net;Port=3306;Data base=data_base;User=data_user; Password=abc123;Option=3;"

And then it dies like a kamikazee lemming at the Grand Canyon.

Any ideas? Thanks!

-DW

P.S. For reference, I'm trying to connect to a MySQL server on our website FROM an access (VBA) form using an On_Click() event.

instead of your domain name use the IP address of your website:

cn.Open "Driver={MySQL ODBC 3.51 Driver};Server=111.11.11.111;Port=3306;Database=da ta_base;User=data_user; Password=abc123;Option=3;"

__________________
Vikash Kumar Singh

Nope. = (

I just gave it a try.
Unfortunately, that line, and everything afterwards, refuses to execute.

Is there anything I should be including as far as external ActiveX controls or something?
I've already included Microsoft ActiveX Data Objects 2.7 and Data Objects Recordsets 2.7

Thanks!

-DW

what is the error message showing up

__________________
Vikash Kumar Singh

By the by - the website is hosted at a place, I just realized, that I CAN'T connect to our website via the IP addy, as it's using the ip address for lots of other sites. It's probably a linux server set to route websites based on the domain name requested by the incoming server.

typing 1.11.1.11 in a web browser won't work. I'd have to type 1.11.1.11/~domain to see our actual site.

Might this have something to do with it and can I get around that?

Dear Vikash:

No error messaged whatsoever. It just stops and won't execute anything after that line.

The original author somehow has disabled error messages, and I am not certain how to re-enable them.

I've been reduced to using MsgBox items to tell me where it stops executing (I.E. MsgBox "Line34" , MsgBox "Line 36" , etc.)

The messagebox right before cn.open executes.
The messagebox right after does not. (I.E. the line of the CN doesn't execute and everything afterwards fails to execute as well)

Found it!

Rather than cn.open "Driver=....etc. etc."

it should be:

cn.ConnectionString = "Driver=....etc. etc."

and then simply:

cn.Open