Connection To MySQL Thru DSN
May 7, 2006
I will create an Access application as a Front end application. The matter is that the users will need to update some data from Internet where there is a MySql server.
I thought in creating a local DSN to connect to that MySql server. Is it right ?
I already created it but... I dont know the code to connect it from Access.
Could you please help me with the code to write in Access ? Im a new with it. sorry.
Or you can send me an example of it in an Access database to: osvaldo@ord.com.ar
Thank you very much
Osvaldo
View Replies
ADVERTISEMENT
Oct 17, 2004
OK, I give up.
I have just finished 4 hours searching and searching.
I have access to a MySQL database that has a time field. I wish to use the DTS packages in SQL Server 2000 to aquire the data to the SQL Server.
I can connect/see it using an ODBC connection, both with access 2k and the DTS bizzo on SQL server.
The time data is being seen by the microsoft end as a date format with way out values.
As MySQL has a very obvious different way of handling date/time (2 data types - one date and the other time), there must be an obvious solution to be able to use this data in access / SQL server.
Hiowever, I cant seem to find it.
damn - fire alarm must go - please help if you understand this - i will ammend later
mike
View 2 Replies
View Related
Sep 26, 2005
Dear Guys,
How to Establish the connection between Ms-Access2000 & Oracle using DAO Connection through Code?.
I created one table in Oracle and I created User-DSN in ODBC.
I linked that oracle table into Ms-Access MDB using Link table option in ms-Access.
Now, Whenever I open that mdb, we need to establish the ODBC connectivity automatically through code (I mean, we need to refresh automatically).
I need to hardcode all the information in the Ms-Access code.
My User DSN Name: abcd
Oracle Database Name: abcd
Schema Name(User Name): abcd
password: abcd
View 1 Replies
View Related
Jan 9, 2005
Right Ok i hope i can get some help cause im absolutely stumped..
i cant get my login page to work since moving it from my PWS(iis on xp) DSN connection
to a 24/7 server on the net with DSNless connection
here is the code for the include file "conntopwd.asp"
http://www.pritchardwebdesign.pwp.blueyonder.co.uk/conntopwd.txt
the username and path has been changed slightly for security purposes,
and the code for the login page which attempts to access the database is here
http://www.pritchardwebdesign.pwp.blueyonder.co.uk/login.txt
the connection has been tested by one of the tech support guys at brinkster and he told me it was ok,
the problem was the way that the data is called from the data base is wrong ..
The tech support guy said that it was this line that was causing the problem..
MM_rsUser.ActiveConnection = MM_conntopwd_STRING
Any help would be much appreciated as im stuck for now..
View 2 Replies
View Related
Oct 28, 2005
I am just a guy in a cube that likes Access and have been able to make it do some great things but am by no means a programmer so...
It seems like the next step is to go with a SQL be and Access fe (network not internet applications) not that what I have isn't doing the job, I just want to swim with the other fish and not be left behind.
So if I could just download a program called SQL that would be great but there are various kinds? SQL Server, MySQL and who knows what else.
I don't know what my company will migrate to in the future (we are currently using A97 and upgrading to 03 soon) and most people here don't even know what a database is. I thought I'd give MySql 5.0 a look, dowloaded it and installed it (don't even know if I answered all the install questions correctly) and started it up and I felt like I was looking at a WordPerfect 5.1 screen all over again (blank blue screen and that was it for those who do not remember). All I saw was a command prompt with "mysql>" that's it.
Now I don't mind doing my reading but I'd just like to know I am going in the right direction before I spend all this time only to find out I should have gone another way.
Is there an easy start method or do I just have to bump and feel my way through all this?
It seems once you leave the calm cool shallow waters of Access you are suddenly faced with strange deep sea creatures called "Programmers".
View 12 Replies
View Related
May 9, 2005
Hello,
I hope I have posted this to the correct forum?
Anyways, I have started porting my database backend to MySQL after a spate of corruptions and speed degrading daily, I have managed to get most things functional but one thing which I can not get working is an odd thing with the FindFirst statement.
I have the following line of code...
rst2.FindFirst "AwaitingStock=True and StockIn=False and DOA=False and Model='" & Trim(Me.Model) & "'"
which works find with Access backend but with MySQL I get the error...
Run-time error '3761':
The decimal field's precision is too small to accept the numeric you attempted to add.
This is obviously not the correct error as I am not trying to add anything!
If I remove the bit about the Model, the code executes fine, also, if I remove all the =True parts and just leave the Model part everything works fine so I guess it is because I am mixing string and integer fields in the search???
Any help greatly appreciated.
Kind regards,
Tom Findlay
View 2 Replies
View Related
Feb 7, 2006
I am building my frist database with MySQL as a backend to Access. I am using the ODBC driver and it looks very interesting. I have a question already though. I know that I can use the InnoDB engine and create relationships within MYSQL to enfro referential integirty, but should I? Or should I create the relationships in Access and let Access do the enforcing? Will my Access application report MySQL errors?
Thanks for the time.
View 2 Replies
View Related
Mar 13, 2006
I have a mysql database on my website (remote db). And i want to link to this database in acess(local bd) so that i can manipulate data.
How is it possible
View 1 Replies
View Related
Apr 22, 2006
Hey, Just wanted to throw the question out there, I already asked another member on their opinion on this but havent heard anything back yet, so im going to also throw the quesation out here as well and see what i get. Im new to databases and started out trying to learn Access with the intention that what i learned in Access i could use to learn MySQL, I figured access was a easier starting point to get my feet wet. I eventaully want to apply my databases to the web and im not sure but just wanted to find out. Does access have capabilities to manage a site where customers create an account on the site and log in and everything?? I was thinking access cant really do it and if it could it might be hard, so thats why i was looking into MySQL. I guess what im really asking is whats the difference between Access and MySQL, and what advantages and disadvantages do they have?? Everybodys opinion is welcome, it all helps me out. Thanks! ~[MikE]~
View 5 Replies
View Related
May 31, 2006
Hello everybody,
Who can help me.
I want to access a MySQL database with ms access.
I cant seem to get it.
Please help me.
Thanks in advance,
John
View 2 Replies
View Related
Oct 16, 2006
Which is better fo running a website which is small?
MySQL or Access?
Sathu
View 1 Replies
View Related
Mar 28, 2008
I notice there is a lot freeware for converting Access database to MySQL. Can anyone recommend one that they've used (with no adware!).
Thanks,
GG.
View 3 Replies
View Related
Jul 18, 2005
I have a split db that is currently on our server. We loaded MySQL onto the server as well. I need to run the db from MySQL, and the person that was working this project before me is now gone. I have no idea where he left off, or what he did to get it to this point. When we try to open the db we get an error message that there is a connection problem with the ODBC. We've installed the most recent patches with no success. This may sound like a really stupid question, but do I need to run the upsizing wizard for this thing to work properly? Thanks for any help you can provide.
View 4 Replies
View Related
Aug 25, 2003
Hello to all
this is my first post
i am havinga problem with my access database
so i started to converted it to MYSQL
but after converting it and running asp script it gives the following error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT tblTopic.Topic_ID FROM tblTopic WHERE tblTopic.Forum_ID = 4 ' at line 1
/mycplus/forum/Default.asp, line 335
and the orignal sql statement in ASP Forums is
strSQL = "SELECT " & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Thread.Topic_ID, " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Message_date "
strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread "
strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND " & strDbTable & "Thread.Topic_ID IN "
strSQL = strSQL & " (SELECT " & strDbTable & "Topic.Topic_ID "
strSQL = strSQL & " FROM " & strDbTable & "Topic "
strSQL = strSQL & " WHERE " & strDbTable & "Topic.Forum_ID = " & intForumID & " "
'strSQL = strSQL & " ORDER BY " & strDbTable & "Topic.Last_entry_date DESC) "
'strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date DESC;"
it was fully working in ASP + Access forums
Thanks
Plz help me
View 2 Replies
View Related
Sep 8, 2005
Hello,
I'm considering using another database server (than Access). The application has more and more users so I would like to upgrade the server to a better DBMS in terms of robustness, security and performance.
The client will remain an access application.
I made my short list but it remains open to include another DBMS : MSDE, SQL server, MySQL, Postgres, ...
Do you have any information that could help me to make the best choice, such as :
- benchmark reports
- compare analysis
- case studies
- your opinion
...
View 1 Replies
View Related
Sep 16, 2005
I have Microsoft Access on my desktop connecting to a MySQL database at my host, using an ODBC driver. I can read the data just fine. But when I try to add another record, it won't seem to do it.
Is it possible to update a MySQL database from MS Access on my desktop?
I have just one table. Very simple. Is it to do with primary key number generation or something?
Thanks,
Jon
View 1 Replies
View Related
Feb 26, 2006
Hi all,
hope someone can help me with this.
Before we moved webhosting company we could have external access to our MySql database which was great as our MS Access system would periodically pull data from our MySql site (namely customer enquiries which were entered via a form on our website) and dump them in our MS Access live quotes table all automatically.
With our current host (which seems to be the norm from my web-searches) they only allow local access to the MySql system.
My question is, how can I oversome this hurdle without having to move hosting company. I really don't want to move again as it's a real pain.
All suggestions welcome.
ahrint
View 2 Replies
View Related
Apr 5, 2006
Hi,
is there any other way to import data from a MySql database then via MyODBC I'm experiencing quite some problems with it (v3.51.12)? , especially with character coding...
thx
Miha
View 6 Replies
View Related
Nov 10, 2005
I have an existing MS Access/MySQL app that I need an experience developer to develop further. The existing application is fairly complex, so experienced developers only.
View 2 Replies
View Related
Feb 2, 2007
On my development machine everything works great, but I know that I'm going to run into problems with distribution.
I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.
Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.
Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.
View 1 Replies
View Related
Jun 8, 2007
I have converted my MS Access database tables to MySQL Server tables. I am trying to use the MS Access front end to cooperate with the MySQL Backend database. I have created a system DSN, without problems.
My issue is when I Open MS Access --> Open File --> Files of Type: ODBC Databases, nothing happens. It does not give me the option to connect to the MySQL database I just created. I also tried to import data by linking tables (again, choosing the ODBC databases option), and it does the same thing. Does anyone know what I may be doing wrong?
View 4 Replies
View Related
Oct 17, 2007
I'm new to access and I'm trying to learn the functionality by creating a relational DB for US zip codes from an excel document. I've imported everything and I have the tables setup. Is there a way to run a MYSQL query like this:
UPDATE tbllocation, tblzipcode SET tbllocation.ZipID = tblzipcode.ZipID WHERE tbllocation.ZipID = tblzipcode.ZipCode;
in access 2007?
Thanks
View 2 Replies
View Related
Jan 24, 2014
I've developed an Acc2003 App that reads from a ODBC linked table.This link was created fro DBwindow->Link table. It often opens a window asking for userNmae and Pwd - I wold liek to aviod this wen distributing the App. So I wrote tis code:
Code:
Public Sub linkOdbcTable(DataSource As String, UID As String, PWD As String, dbName As String, ParamArray Tables())
Dim dbs As Database
Dim tbl As Variant
Dim rst As DAO.Recordset
Dim linked As Boolean
Dim ConnectionString As String
[code]....
View 6 Replies
View Related
Apr 28, 2015
I have an Access front end and backend right now, however when I made the backend I made it so that Access stores the attachments in the backend instead of a path to the backend. Now the database is growing rapidly and I need to migrate to a MySQL backend. I'm not sure how this will work with the attachments though? I definitely want to just store paths to the attachments in the MySQL database. Whats the best way to do this?
View 7 Replies
View Related
Oct 31, 2005
Could someone please help me?
At work we have a website with a mysql database attached to it. It keeps data such as customer name address postcode contact id etc.
Currently our main database is made in access.
I need to transfer data from the website database (which is in mysql) to our access database. And would like this to happen regulary. We have been quoted £1800 for someone to do this!
As this is a new job i would like to be able to do this myself, is it hard to do?
Could someone provide me with some information of how to do this? or where to start.
Much appriciated.
View 3 Replies
View Related
Jul 17, 2007
Hi There,
Whereabouts would I change the date format from the access database from yyyymmdd ?
I am trying to convert this table from access into mysql, and when I ouput to a csv file the date is in access.
Many Thanks
Chris
View 1 Replies
View Related
