Remote Conn Via ODBC Or Web Services?
I need your help, I've developed an application succesfully using PHP and MySQL
But in order to mantain the MySQL database I need to make constant connections from either Progress or Delphi
It's been working just fine using the MySQL ODBC 3.51 connector, but only in the SAME machine (localhost) any other machine atmysqlting to connect remotely gets an error
This implementation works if my customer has a dedicated server posted on the web, but other customers need to hire external hostings
In that case, how can I connect progress or delphi to a REMOTE MySQL DB on a external SERVER?
View Complete Forum Thread with Replies
Related Forum Messages:
Remote ODBC Tables Via MySQL
I've been using MySQL as a db engine behind a PHP application, and it has worked very well so far. Now I need to access some data held in a remote Oracle database and the only access I'm likely to get is via ODBC. I know the federated engine only works with MySQL, but is there a way of viewing these tables through MySQL? It would be much simpler (and more portable in the long run) to maintain an illusion for the app that it is looking at only one database. If there's no way to do this, will I need to set up a script that dumps data into the local database?
View Replies !
Data Transfer Services
Does anyone did DTS using MYSQL before? thinking to migrate from MSSQL to MYSQL.. If MYSQL can do DTS, then I don't need to do scripting to transfer data.
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
Windows SQL Services And Removing MySQL
I had installed mySQL when a programmer wanted to use it for a project. Then i uninstalled it. Now the MS SQL services (SQLserver, sql server activation directory helper, sql server browser, and sql server vss writer), cannot be started. The error messages seem to indicate that there are some files missing in order to run the services. I tried to re-install MySQL, but not it is giving me error zero when i run the configurator.
View Replies !
Mysql Stock In Services Forgot To Remove
i have uninstalled mysql to put it on a different drive soon The old mysql stayd in Services and I dunno how to remove it from administrative services? Mysql is not installed atm i will install it soon in other words how do I remove from administartive services once i uninstall the whole thing.
View Replies !
Unable To Connect To Database :: Odbc.ini Or The Odbc.inf
We are using MySQL on Linux server and "NetCOBOL V7.0L10" to access our MySQL database. Our Linux ODBC driver description is "MyODBC 2.50 Driver DSN". When trying to establish a connection to the database, we receive an SQLSTATE value of "S00?M" where "?" changes with each execution. The SQLCODE value is always 00000104 and the SQLMSG is always "[nxDC[C]MOB]cesdne o sr sxlclot Uigpswr:YS". We suspect that there is something wrong with either the odbc.ini or the odbc.inf file definitions but can't quite determine what the error is.
View Replies !
ODBC Connection :: ODBC -- Call Failed
I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL ODBC drivers. Each time I try to connect I get the following error: ***************************** ODBC --call failed. [TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130) *****************************
View Replies !
MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would like to schedule a task on my local Windows computer to retrieve a backup/dump of this remote database. I have contacted my host, and they indicated that the server is only open to the Internet via mySQL. Therefore, even if I did have access to that server's command line (which I don't) to create dumps via mysqldump, I would not be able to retrieve via FTP. Does anybody have any ideas as to how I can generate backup files from my local computer through a local command-line interface? I have done it through a GUI (DBTools), but I would like to have it done via DOS batch, so that I can schedule it. Does anyone know of any mysql backup GUIs with command line switches? Or can somebody recommend an alternate means of getting a local backup?
View Replies !
ODBC?
So I'm running MySQL on Win XP(SP2), on a Athlon 64 in a Asus MB. I downloaded the ODBC 3.51 installer and ran it... When I looked in the MySQLAdmin service still says "Not Found Driver Version Driver E:WINDOWSSYSTEM32myodbc3.dll API Level Setup E:WINDOWSsystem32myodbc3S.dll SQL Level " In the MyODBC secton. I tried stopping the service and restarting it. I've restarted several times. Is there something I'm doing wrong? or is the service just innaccurate?
View Replies !
Connecting To ODBC
I have transferred the data from Access to MySQL using MySQL's tool. The transfer worked great and saved me a lot of time (thanks MySQL). Now I'm trying to get the Access database, or a new access database, to talk across ODBC and see the data. I created the DSN through the control panel and it works without error. How do I setup Access so it can see the data. The data was on windows (M$ Access) and is now on linux (Fedora Core 5). Followup: Seems like it connects, the 'Test' in the DSN definition returns data. I turned on logging through the DSN dialog and I see traffic between the DSN/application (MS Access) and the MySQL server. Still, I do not see anything usable returned from the MySQL server to Access.
View Replies !
ODBC W/ Password
I am using mysql 4.1.2 on a Win2K (SP3) host. I cannot seem to create a useable MyODBC DSN unless I set user=ODBC with no password. When I try to test a non-null password in the DSN configuration dialog for ODBC 3.51 I get the error message: "[MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client" This sounds like a server configuration issue but the client (presumably the ODBC driver in this case?) is being blamed, apparently. I have tried this on both MyODBC 3.51 and 2.50, getting nowhere.
View Replies !
Bookmarks And ODBC
I am porting C code originally written to talk to a SQL Server engine via ODBC. While many of the differences are mainly annoyances, and I found work arounds, I have run across one big issue. The MySql driver (3.51.06) doesn't support bookmarks. The only time this is a real problem is when I need to get the value of an auto-incremented column after an insert.
View Replies !
Delphi And ODBC
I have been an avid MySQL and Perl developer for several years now. I have always used DBI and DBD for perl. Very familiar with this. I have been assigned to write a Delphi application that stores data into a MySQL database. I really have no idea of how to do this and how to access MySQL from within a Delphi application. Can anyone give me some hints and some links to go to so I can learn this? I'm sure it is not hard, but just not sure where to look. I tried googling for it, but links I found were not very informative.
View Replies !
Merge The ODBC
I developed program by vb6 and mysql database.If I would to merge the ODBC of mysql and setup of my program in one file how is it?
View Replies !
MySQL 5.0 And ODBC
Tried the ODBC 5 connector that MySQL provides - it is an Alpha product and is really not ready for prime time. Does anyone know of any 3rd party ODBC connectors - even commercial ones - that are ready for MySQL 5.0 and support the new stpred proc with parameters functionality in MySQL 5?
View Replies !
Odbc Driver
i am using Access 2003 connecting to mysql 4. and newest odbc driver, and i set a checkbox form control bound to a unsigned integer field in my database. if its intially set to 0, or 1. it will be checked in my access form. if i uncheck it, it will update my mysql database accordingly to 0. but if i check an unchcked box, it will not let me do it. it seems to send -1 to the field whoever at microsft made (-1 == yes) should die lol. anyone know a way to make access recognize it, or fix odbc driver so it knows if microsoft uses the driver to convert -1 to 0? my best solution is make a trigger on update, and if that new value is -1 set it to , hoping it wont spit back error back to Access for the inital -1 being wrong. any other ideas? wish i knew what event to override to do my own insertion. if checked, UPDATE with 1, if unchcked, UPDATE with 0.
View Replies !
ODBC Not Support Utf?
my host only gives me ODBC connection to MySQL. i need the table to store some chinese characters and display them to the ASP.NET form. when i tested MySql connector on my dev machine, i added CHARSET=utf8 to the connection string and set the column charset to utf8 and it worked well. i did the same thing while using ODBC 3.51 Driver but all i saw was ????. am i missing anything or ODBC 3.51 Driver simply doesn't support utf?
View Replies !
JSP / Servlets And ODBC
I am trying to create a Data Source Name for MySQL with ODBC and I keep getting an error. I am trying to get servlets to work with JSP and MySQL database. I used PHP before and the database can be accessed fine. The error is: [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Perhaps I am not configuring it correctly? I am using TOMCAT for Apache and so I am entering a localhost on Port 8080... Should the server be 'localhost' with '8080' under Connect Options or 'localhost:8080'? Is a user and password specified somewhere else or can I just make one up there?
View Replies !
ODBC Connnection
i am using a simple MySqlPhp Generator to generate forms all is done well however when i run the file which is generated this comes up Access denied for user 'ODBC'@'localhost' (using password: NO) and to solve this problem all i did was take out the root password from my database and connect without the password all works fine if i do that however i want set a password to my database but when i do that the error message comes up "Access denied for user 'ODBC'@'localhost' (using password: NO)" how do i solve this? i am using mysql 4.1 apache 2.0.59 php 4.47
View Replies !
ODBC Connectivity
I downloaded the MySql ODBC driver and have tried to create a System DSN...I get this error if point to IP or domain name: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysqlname.mydomainname.com' (11004)
View Replies !
ODBC Connector
I need it for using the ODBC connector. How can I found out what it is? Is there a PERL script or PHP that I can use to get the actual hostname? Can they "disable" access to it via its URL or something?
View Replies !
ODBC CONNECTIONS
We are in the process of setting up a database to house some information from our (legacy) ERP. Two questions have arisen: 1. Can we create a direct link to the data source from the db? 2. Currently we are using access as an intermediate connection - the link to the dsn in in access and then we have been exporting the data to the MySQL table. However, this will not let us update the tables it creates because it says the file already exists. If we stay with this method, how do we update the tables on a nightly basis (needs to be an automatic function).
View Replies !
ODBC Message
I have a mysql 3.23.49. It's working on Linux Red Hat, all our application run in Windows XP connecting through ODBC driver. We've been receiving some warning messages recently, but that application run more than 3 years and we'd never received that message: Warning: Lost connection to MySQL server during query The computer has 4 cpu (1.5Mhz), 2G RAM and free space in Hard Disk, it's only database server. Where can I start analize from? The top command, most of time show mysql working with 100% cpu.
View Replies !
Odbc Drivers: WTF?
In winmysql admin, I was getting errors that it couldn't find drivers for odbc 3.51. Although I can't understand why it isn't included with the mysql package, I found odbc, and installed it. Now I get this error: not found Driver Version driver C://Windows/System32/myodbc3.dll API Level Setup C://Windows/System32/myodbc3s.dll SQL Level
View Replies !
Using MySQL From ADO.NET And ASP.NET Via ODBC
I have the following problem when I try and connect to MySQL - REGDB_E_CLASSNOTREG(0x80040154) - (MySQL ODBC 3.51 Driver). I have used this driver via VB6 using ADO and ODBC without a problem. The connection string I'm using in ASP.NET and using .NET Framework 1.1 and MDAC 2.8 RTM is: MyConnectionString = "Provider=(MySQL ODBC 3.51 Driver);Data Source=localhost;uid=;initial catalog=property;password="
View Replies !
ODBC Error In V5
I am using ODBCv5 but when I run: [code].... There is an error "ODBC DRIVER does not support the requested properties". I am using Visual basic 6 running in windows professional with sp2.
View Replies !
ODBC Commercial Use ...
I can't post any messages @ the Licensing-Forum, so I have to ask here oO . So I want to create a Software and sell it. Do i need to buy a license if i'm just using ODBC and not really MySQL it's self?
View Replies !
ODBC Or DDE Link Help
I have a MYSQL database and use PHP to query it as well as display web pages. I have a third party application which has fields I can copy and paste into an excel spreadsheet and using DDE links the excel cells automatically update when refreshed. I would like to apply the same theory to MYSQL or PHP instead of Excel. When a web page is refreshed it queries the third party application and gives updated values, or maybe some way to update a MYSQL table with the data. I have looked up ODBC connectivity, OLE Links and DDE links. I can see that it is possible to have Excel or Access query MYSQL but not sure if MYSQL or PHP can query the third party app.
View Replies !
ODBC Setup
I have a Windows 2000 Server preinstalled with mySql, and have tried to run a basic connection test though the ODBC manager for the mySql Server Driver, and it continues to say it can not find mySQL. When setting up a standard database through the ODBC Manager, here is the basic info it provides. Code:
View Replies !
ODBC: Login
This is kind off topic how to connect to ODBC. <?php $server = "real_dsn_server:3180"; $user = "root"; $password = "admin4"; $dbnameID="info";?> <?php $conn=odbc_connect($server, $user, $password); $sql="SELECT * FROM $dbnameID"; $result=odbc_exec($conn,$sql); echo "SUCCESS";?> I got the following error: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in odbc_log.php on line 10 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in odbc_log.php on line 12 SUCCESS Why is that? Even though I can DSN in control Panel>ODBC on windows XP Pro and it said successfully.
View Replies !
Win XP Missing MySQL ODBC 3.51
Windows XP sp2, Installed MyODBC 3.51 and the driver. It does not appear in the User/System DSN ODBC control panel. Does not appear in the driver tab Is listed in the ODBCINST.INI and appears in the registry REGEDIT4 Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMySQ L ODBC 3.51 Driver] "UsageCount"=dword:0000000c "Driver"="C:WINDOWSsystem32myodbc3.dll" "Setup"="C:WINDOWSsystem32myodbc3S.dll" "APILevel"="2" "ConnectFunctions"="YYN"
View Replies !
ODBC Connection Using Access
I am using Access 2K as a front end to MySQL running on a Linux server. I am having trouble connectiong to the server. MySQL control centre connects and I can connect using a DSN data source. But if I connect using the following code: Dim constr As String Dim tbl As DAO.TableDef constr = "ODBC;DRIVER={MySQL ODBC 3.51 Driver};DESC=;USER=" & SQLServerUser _ & ";DATABASE=" & SQLServerDatabase _ & ";SERVER=" & SQLServer _ & ";PASSWORD=" & SQLServerPassword _ & ";PORT=;OPTION=;STMT=;;TABLE=" & MYTABLENAME tbl.Connect = constr tbl.SourceTableName = MYTABLENAME DoEvents CurrentDb.TableDefs.Append tbl I get a Cannot find installable ISAM error message when trying to append the table. It appears that a connection is made but that I cannot access any of the tables. I have tried using other connection methods and get the same results. If I change the above to constr = "DSN=MYDSNCONNECTION;DESC=;USER=" & SQLServerUser _ & ";DATABASE=" & SQLServerDatabase _ & ";SERVER=" & SQLServer _ & ";PASSWORD=" & SQLServerPassword _ & ";PORT=;OPTION=;STMT=;;TABLE=" & MYTABLENAME Where MYDSNCONNECTION is the DSN connection set up in the data sources, the code works and the table is appended.
View Replies !
ODBC Version Trouble Between 3.51.10.00 And 3.51.11.00
we are dealing with some very specific problems with ODBC, where a connection from SQL-Server to Mysql works with ODBC-driver 3.51.10.00 and does NOT work with ODBC-driver 3.51.11.00. Maybe someone experiences similar problems or even has a solution ? We use a Microsoft SQL-Server as Headquarter database and some Mysql-machines on Redhat as satellite-databases. We use a script to copy and replicate data between satellite and headquarter. This script is using simple SQL connecting to Mysql-database using ODBC and "Openrowset". In order to copy only new data from sattelites we use the Binary_Checksum function from Microsoft SQL-Server. This works with the 3.51.10.00 version perfectly but it fails with the 3.51.11.00 version, where it gives us the message (from MS-SQL-Server) "msg 8481 Error expanding "*": all columns incomparable, '*' expanded to zero columns". This message comes only for some but not for all statements using the binary_checksum. The only way to fix this is to stick with the "old" version of the ODBC-driver. Could someone please explain what is going one?
View Replies !
Making ODBC Work
When trying to set up programs (dbQwikSite, Adobe Designer) to work with ODBC databases, I encounter the following during setup of the programs: "it connects, but if I set the initial catalog to any database it says: "Test connection failed because of an error initializing provider. Catastrophic Failure." But when I connect with the initial catalog field empty it connects successfully.How do I fix this problem?
View Replies !
Mysql Access Through ODBC
I have a Mysql table which has over 40000 records. If i want to access from VB using ODBC connection. will that be good choice related to performance wise. or any other options there.
View Replies !
User Permission And ODBC
I am using SQLyog. I want to manage user permissions down to a field level which SQLyog does. Any DDL or DML statements that I attempt to execute within SQLyog support the defined user permissions. However, when I use MySQLCC the persmissions are totally ignored. This is also true when I attempt to access the database through ODBC using a number of third-party tools. My intent is to offer my clients the ability to access their data through ODBC with the option to restrict a specific set of users to sensitive data (Financials or salary amount column for Payroll) using a tool such as SQLyog. Is this possible that one tool has the permission and another not?
View Replies !
ODBC Driver Setup
I have setup an ODBC driver for my MySQL database and use a 3rd party program to connect to it. Everytime the software connects, the ODBC driver setup screen pops up. I have to click OK on it to continue. I set the parameter "Dont prompt on connect" in the options but this has not solved the issue. The system setup is Win2K SP2, MySQL 4.0.15, MySQL ODBC driver 3.51.
View Replies !
ODBC Client Problems
I've just installed 4.1.0-alpha-max-nt onto my server and now my 3.51 ODBC client says Client does not support authentication protocol requested by server. Consider upgrading MYSQL client Am I missing something obvious because I cannot find a more up to date client? Or do I need to go back a version of the server to keep working ODBC?
View Replies !
ODBC Connection Keeps Dropping Off...
I have a local user on our network running MS Access 2003 (on Win XP Home), which needs to connect to a Back-End MySQL DB on our Cobalt Qube 3 Server. I installed the correct software to run the Access on their Win XP OS, and installed the ODBC MySQL Driver 3.51. When I test the connection in the ODBC panel, CONNECTED ! Then I open MS Access, and great, the app works. If I then close MS Access and re-open, as soon as I hit a button which needs data from MySQL then I get an error stating that this IP cannot connect to the MySQL DB using Password (Yes). I have tried taking the password out of the DSN, and user account for MySQL, but this makes no difference. After the second time trying to open MS Access, it brings up the ODBC Admin panel, and I have to delete the password and try to connect, 'connection failed', then enter the password 'connected!'. If I then open Access it runs, if I then exit & re-start the app 'Cannot connect using IP........., using Password...) I have double checked all the settings in the DSN, and their user account for the MySQL DB. Surely, the PC should be able to connect either all the time, or not at all, not just once, and then lose the connection
View Replies !
MySQL ODBC 3.51 Driver
I have just installed the MySQL ODBC driver 3.51 on an XP machine which is behind a proxy.When I configure my DSN, I can't access the MySQL server which is in the "outside" world.I get this error: [MySQL] [ODBC 3.51 Driver] Unknown MySQL Server Host 'mysqlserver.com' (11004) When I click the [Configure] button in my DSN configuration, I cannot see any field to define a proxy.
View Replies !
ODBC Driver Version 03.51.08
I just installed the last version of the MySQL ODBC driver, version 03.51.08 A bug in the previous version (Default values not returned by the function SQLGetColumns() was corrected and works properly now. However, the following problem still exists: A call to the function SQGetInfo() with SQL_ALTER_TABLE does not return the bitmask SQL_AT_ADD_COLUMN_DEFAULT set, although MySQL does allow default values in ADD COLUMN. The equivalent bitmask for a call with SQL_CREATE_TABLE does return the bit set correctly.
View Replies !
Problem With ODBC Connector
I just installed the last version of the MySQL ODBC driver, version 03.51.08 A bug in the previous version (Default values not returned by the function SQLGetColumns() was corrected and works properly now. However, the following problem still exists:
View Replies !
Access Denied For 'ODBC'
The thread that the link links to is posted in the PHP forum, but ideas for resolution are running out. It's MySQL related so i figured I'd see if I could get some MySQL config tips. http://forums.devshed.com/t278390/s.html
View Replies !
|
TRACKER
