UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Passthrough Query Connection String., Access 2010    
 
   
expatriate
post Feb 10 2017, 02:40 AM
Post#1



Posts: 390
Joined: 23-April 10
From: Thailand


I use this string to link my MySQL tables successfully.
"ODBC;DRIVER={MySQL ODBC 5.3 ANSI Driver}; SERVER=localhost; DATABASE=xx_ver2; UID=xxx; PASSWORD=xxx; OPTION=3;Keepalive=60"

when I put it as the connection string in the property window for a passthrough query (which is a stored procedure), I get an error "invalid connection string".

Thanks.
Go to the top of the page
 
PhilS
post Feb 10 2017, 02:53 AM
Post#2



Posts: 364
Joined: 26-May 15
From: The middle of Germany


Not sure if this is the cause of your problem, but usually connection strings do not contain unnecessary spaces. Otherwise the strings look fine to me.

--------------------
The shocking revelation about digital signatures for accdb files.
Go to the top of the page
 
expatriate
post Feb 10 2017, 06:20 AM
Post#3



Posts: 390
Joined: 23-April 10
From: Thailand


I got this working using a DSN as the connection, but still, if anyone knows why the string will not work, it's something I'd also like to know.
Go to the top of the page
 
PhilS
post Feb 10 2017, 07:09 AM
Post#4



Posts: 364
Joined: 26-May 15
From: The middle of Germany


QUOTE
"ODBC;DRIVER={MySQL ODBC 5.3 ANSI Driver}; SERVER=localhost; DATABASE=xx_ver2; UID=xxx; PASSWORD=xxx; OPTION=3;Keepalive=60"

You did not paste those highlighted quotes into the property window, did you?

--------------------
The shocking revelation about digital signatures for accdb files.
Go to the top of the page
 
expatriate
post Feb 10 2017, 07:49 AM
Post#5



Posts: 390
Joined: 23-April 10
From: Thailand


Do I have to answer? pullhair.gif Works now. Thanks.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    24th September 2017 - 10:53 AM