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 Complete Forum Thread with Replies
Related Forum Messages:
Slowing Brute Force Attack :: Sleep() Call After Failed Connection
Is there an option for mysqld to add a sleep() call after each failed connection request, before reporting to the client (to slow down brute force attack)? I glanced at the manual and there doesn't seem to be one. If there isn't, would it be a good idea? If yes, I could probably submit a patch. This feature should be trivial to implement, I think.
View Replies !
ODBC Connection :: Unable To Create DSN Connection
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
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 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 !
ODBC Connection Error
I am trying to configure an ODBC connection to a MySQL database, 5.0.12 Beta-nt. We testing the connection I get the following error; [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query If I try to connect via cmd prompt the following message is displayed; ERROR 2013 (HY000) : Lost connection to MySQL server during query The strange thing is if I disable Norton Internet Security all works fine. The Windows Xp firewall is turned off and Norton has been configured to allow MySQL.
View Replies !
Jdbc / Odbc Connection
I am running Suse 10.1 and i have MySQL working fine but Im having problems with connecting my Java Application with my Database. I got the recent J Connector drivers but i keep getting the exception about it not being able to find my device driver. The only other thing I was un-able to figre is where is "%Java_home% /jre/lib" is that only for windows?
View Replies !
ODBC Connection Failure
Does anyone know how to solve this connection problem ? [MySQL][ODBC 3.51 Driver]Host 'adsl-76-205-58-150.dsl.pltn13.sbcglobal.net' is not allowed to connect to this MySQL server This connection works fine when I am in a static IP environment but does not when I am using DSL from home.
View Replies !
ODBC Connection String
I am writing the C++ code that will connect to the mySQL database. It will use ODBC. I have a mySQL + unixODBC + myodbc installed on my Linux box. I created a DSN for my user and can successfully connect to the DB 'localhost' from isql. isql test root I put the password in the odbc.ini file. However, when writing the C++ code, I need a connection string. So far I tried: DSN=test;UID=root;PWD=<password> DSN=test;UID=root;Password=<password> However, the program does not connect to the server.
View Replies !
ODBC Connection Timeout
Hope someone can help me with ODBC connection error I'm having. Have installed mysql 5.0.12 beta-nt and ODBC 3.51.12 on XpPro sp2 machine. I have configured the driver and all works well untill I activate Norton Internet Security. If this is enabled and I use the ODBC configuration tool to test the connection I get the following error; [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query Windows firewall is turned off and Norton has been configured to allow MySQL. Is the Norton thing a red herring .
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 / MySQL Connection Issue
I'm trying to allow someone from a specific IP to connect to a mySQL db w/OBDC. I've run several GRANT queries on the mysql db i.e. GRANT select,update,insert,delete,create,drop,alter,inde x on ESdemo.* to 'aname'@'24.55.41.125' identified by 'pwd232123'; GRANT select,update,insert,delete,create,drop,alter,inde x on ESdemostore.* to 'aname'@'santamonica-cuda4-24-55-40-1.vnnyca.adelphia.net' identified by 'pwd232123'; but when I try to connect I get "Request returned with SQL_ERROR." Any ideas? Does it sound like a GRANT issue?
View Replies !
MySQL ODBC Connection Problem
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
View Replies !
ODBC Connection To External MySQL DB
I am running VB6 (old I know) and trying to connect to an external database (on my server). I have the "MySQL Connector/ODBC 3.51" installed (which I think I need). However when I run my VB6 application I am getting the following error: Run-time error ?' HY000 [MYSQL][ODBC 3.51 driver] could not find driver {MYSql ODBC 3.51} in system information. I was able to do this on my older server, from my old home PC ages ago but I can't remember what I did to get it work.
View Replies !
Odbc Connection :: Get Data From Excel Sheet
I have excel running on a macintosh OS X box. My webserver is on a linux box with mysql and php on it. Is there a way i can create an odbc connection so that I can get mysql data to my excel spreadsheet from excel? OR Can I use odbc to connect to a mysql database on a remote machine? I want to write a macro in excel which should retrieve data from mysql. I am basically in a situation where I had created a web interface from an excel worksheet, and now I can add new records via the web. But now I have to get the data back to excel(in fact I have to update the very same excel worksheet). Sounds redundant, but I have to do this.
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
Slow Performance :: Navicat To Import Tables From An ODBC Connection
have been using Navicat to import tables from an ODBC connection I have. The import goes extremely fast but once the data is locally stored and I try to manipulate it by joining tables, the program goes slower and sometimes even crashes it. If the same data is however imported into a table in MS Access, and a query is created it runs fine. I would like to know if there is a way to improve the performance of my MySQL database as the reason I was using it is because of its scalability. I was wondering if there was something I was doing wrong or could do better. The Server the data is downloaded to right now is has the following specs: Windows XP Pro Intel Core 2 CPU 2.13 Ghz 2 GB RAM
View Replies !
Connection Failed
Running mysql on localhost is not problem (connecting and all that). Its when I try to connect to mysql from something thats not localhost that problems begin. Im using MySQL Query Browser to connect from my home computer and I keep getting this message: MySQL Error number 2003 Cant connect to MySQL server on bla bla bla... I made sure that the user im working with is 'user'@'%' granting all privileges using commandline in mysql and phpMySQL and its still not connecting.... mysql> show grants; | GRANT ALL PRIVILEGES ON *.* TO 'my_user'@'%' IDENTIFIED BY PASSWORD '*D1A4EA9EEEEEE8F69F709A5F0F96DDDD0F78ED6D05F' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `my\_table`.* TO 'my_user'@'%' WITH GRANT OPTION
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 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 !
|
TRACKER
