excel - Connect VBA to MySQL -


i know has been asked many times, none of them helped in case.

so here piece of code:

dim oconn adodb.connection  sub macro1()  set oconn = new adodb.connection oconn.connectionstring = "driver={mysql odbc 5.2 ansi driver};" _ & "server=server;" _ & "database=db;" _ & "uid=user;pwd=pw; option=3"  oconn.open 

enter image description here

enter image description here

what wrong?


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -