RE: MS Access
"Whisler, Dave" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
I switched from DSN to DSN-less with my MS-Access front-end and Oracle back-end database apps a year ago and it works really well. So much easier to manage than DSN's. Basically, I put the following text in a text file and reference it when creating a new table-link in MS-Access to a table on my Oracle Server. [ODBC] DRIVER=Oracle in OraHome92 SERVER=dbserv2 DBQ=dbserv2 Of course you'd need to change the "Driver" variable to be the name of the MySQL driver and the "Server" and "DBQ" variables to the name of your MySQL instance. David K. Whisler Oracle & MySQL Database Adminstrator & Developer The William States Lee College of Engineering UNC Charlotte -----Original Message----- From: Jess Balint [mailto:[email protected]] Sent: Thursday, June 12, 2008 1:53 PM To: Ron Cc: [email protected] Subject: Re: MS Access 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] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]