Re: MS Access
Jess Balint <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Ron - Yes, it is possible to use a "DSN-less" connection through Access and we use it in some of our test-cases. Can you provide more information on the error you received? Maybe the relevant portion from the ODBC trace log? Jess On Wed, Jun 11, 2008 at 09:30:22PM +0100, Ron wrote: > Sir > > Can the connection string format of myodbc 3.5 be used in vba code within MS > Access or does one only have the option to set up an odbc data source. > > I have a test Access db in which I can create table links to a MySql db > located on a web server using an odbc data source. > However, when I try to use the connection string method, I get the 3170 ISAM > error. The format of the connections string matches all the examples I can > find on the web. > > Also, if I try to to set a reference in VBA by browsing, I am told that a > reference cannot be made to the selected file. > > > I'm new to MySql. Hence, I have downloaded the latestest versions. > > > > Thank you for any help that can be given. > > > > > Regards > > Ron Bolton > > t:0117 9790233 > m:07801 352638 > > www.baselogicsoftware.co.uk > > > > -- > MySQL ODBC Mailing List > For list archives: http://lists.mysql.com/myodbc > To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]