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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
Unable To Establish Connection To MySQL
I have a PHPFusion site hosted by Servage. I keep recieving this error, it can be a simple refresh of my site or, clicking on different links. Unable to establish connection to MySQL 2002 : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) It doesn't do it all the time but, it happens daily. Could anyone tell me if this is a problem with my hosting provider or, if this is some script error on my site?
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 !
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 !
Create Connection
How much time it takes to create connection to MySQL and to execute a insert query . which one is better in MySQL in following condition :- i m inserting a message for each recieved packet from network to my m/c. e.g 30 messages per second. means 30 queries per sec. Please help me. which one is better: 1) i opens only one connecion and go on inserting. 2) open and close connection for each message. 3) give me time taken to create connection and close connection. 4) disadvantages of making a connection open.
View Replies !
Create Connection Object
The database has already been made and is installed in http://TL28serv and has a dsn of "warehouse". It says to connect to the database you need to use the following connection string: myconn.open"warehouse","IWSDstudent","assign2" (this is assuming that the connection object you create is called myconn). Does any one know how to create this connection object? and how to use the connection string?
View Replies !
Does Each SELECT Statement Create A New Connection?
I've developed and currently maintain a company website which is hosted on a shared server plan. I have a modest grasp of the ins and outs of connecting to and retrieving data from mysql. However, When a user visits our website, a connection to the database is made to retrieve the pages needed data. In this example there's one SELECT statement. So, one connection, one SELECT statement. But, what if the biggest page on our site is written like this: ....
View Replies !
CREATE INDEX Crashes Server (Lost Connection...)
I'm having trouble with a table I created quite a while ago and now want to add an index to. Here's what I get if I try to add an index on the host field of my table: mysql> create index Index_host on uselog(host); ERROR 2013 (HY000): Lost connection to MySQL server during query Connection was lost because the server crashed. The Windows event log has an event that says "Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x0017dc06." I've also tried the allegedly identical "ALTER TABLE uselog ADD INDEX Index_host(host)", as well as trying to index a different column, all with the same outcome (server crash). Thing is, I had no trouble adding an index to the same table a week or so ago. The table was smaller then (and had only one index), but even now, it's not very big by DB standards, so I can't imagine that's the problem. (My table had ~900K rows earlier today, which I pruned down to 140K rows after my first failed attempt to add the index. Puny! Only 55MB data length, according to MySQL administrator.)
View Replies !
Lost Connection To MySQL Server During Query (create Database)
I downloaded the MySQL trail version a few month ago, it worked fine. however after i brought 1 x EMS MySQL Manager Professional (Non-commercial license) and registered but the tool doesn't work anymore... when i try to register a database and try to get it connect, it through me a error message "Lost connection to MySQL server during query". more to it... when i try to create a database at my local host, a error messate says "can't connect to MySQL server on localhost (10061)... PLease help!
View Replies !
Changes Made In One Connection Does Not Reveal In Another Connection At Once.
I use many connection and the same as many threads in my server app to gain performance on a multicpu machine. Firstlly i call "set autocommit=0" and wrap every statements with "start transaction " and "commit". i use mysql_stmt_execute for every statement rather than mysql_real_execute except those that can't be prepared. The version of mysql is 4.1.11 under Debian linux. In one connection of one THREAD i insert a row into a table. After i got the sucess code and the last insert id, i then do a "select" from another connection in another THREAD with the "last insert id" return by the previous insert . I expect the select can fetch the row that i have just insert , but some time it does and some time it doesn't. is there any funtion like "mysql_....flush...cache.." to make the changes from one connection to be reveal to the global at once?
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 !
Unable To Use ODBC On Windows Server
I use to be able to connect to mysql on my testserver...this was through ODBC. Now for some reason, I cant connect to the testserver threw ODBC anymore... And when i get the error it says im trying to access the local host.. Heres a Picture of what i get: http://img28.picoodle.com/img/img28/4/7/8/f_WTF2m_00b267b.jpg I can still connect to "other" servers correctly.. I tried reinstalling myODBC on the windows machine... also I tried: GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.my.comp'; FLUSH PRIVILEGES; when that didn't work i tried GRANT ALL PRIVILEGES ON *.* TO 'root'@'*'; FLUSH PRIVILEGES;
View Replies !
Unable To Create Table
I'm trying to create a table in a database in mysql but I keep getting an error...I posted it below can someone tell me why I'm getting this error: mysql> use bob Database changed mysql> create tables checks -> (check varchar(6) not null, -> payee varchar(20) not null, -> amount varchar(6,2) not null, -> remarks varchar(20) not null); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table s checks (check varchar(6) not null, payee varchar(20) not null, amount var' at line 1
View Replies !
Unable To Create Database
Would any kind soul enlighten me on the error msg? Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource I kept on receive this warnings for almost 50 pages long! and the database fail to create, what could be wrong?
View Replies !
Unable To Create Auto_Increment Field
I want to have an auto_increment field in my DB but when i type in : ALTER TABLE `test` ADD `id` SMALLINT( 11 ) DEFAULT '1' NOT NULL AUTO_INCREMENT FIRST it wrotes:#1067 - Invalid default value for 'id' but why can't i set the default on 1? I tried also other numbers, but it doesn't work.
View Replies !
Phpmyadmin :: Unable To Login After Create Of New DB
When i create new db and user inside that db, i cannot use phpmyadmin to login. I'm sure the user/pass are correct. Also, my exisiting DB working fine using phpmyadmin. I dont know what is the problem as i cannot see error. Only the dialog box that request user/pass is keeping to refresh asking me to login.
View Replies !
Unable To Create Innodb Tables In Mysql
i am unable to create tables in mysql under InnoDB engine, whatever i do, it simply creates table under default MyISAM engine, why is it so ?? I tried making the table thru commandline, using the following command, which is exact copy from mysql official website MySQL Code: CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=INNODB; then, tried creating thru mysql query browser, but no luck .. i am unable to run transactions using php due to this reason,
View Replies !
Unable To Create User-defined Data Type
I want to create a user defined data type, but when I use the syntax: CREATE DOMAIN newdataType AS INTEGER; (for example) MYSQL returns the following error message: ERROR 1064 (42000) : You have an error in your sql syntax; check the manual that corresponds to your MYSQL Server version for the right syntax to use CREATE DOMAIN newdataType AS INTEGER; I have checked the MYSQL documentation and this forum but came up empty.
View Replies !
Connection Through PHP
My setup is windows xp , apache 2 , php 4.3.10 , mysql 4.1.8 ... Php and apache work fine , and i can control mysql via command line . But ...When i try to control mysql via php with the follow script : <?php $connection = mysql_connect ( "localhost", "root", "") or die ( "unable to connect to MySQL" ); echo( "connected to MySQL" ); ?> I take the next message : Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in C:Program FilesApache GroupApache2htdocsSitesTestain.php on line 9 unable to connect to MySQL
View Replies !
Unable To Create Full Text Search Index On A Column
I have installed MySQL 5.0 on my WinXP machine. I have created a test schema in which I have created a test table as follows: Test_Table { Id => Integer and Primary Key Name => Char(255) Address => Char(255) Tags => TEXT } Now I want to create a full text seach index on column Tags, but when ever I try to execute following SQL statement: ALTER TABLE `TEST_TABLE` ADD FULLTEXT `Index_FTS`(`Tags`); I get following error: Error while executing query: ALTER TABLE `TEST_TABLE` ADD FULLTEXT `Index_FTS`(`Tags`); MySQL Error Number 1283 Column 'Tags' cannot be part of FULLTEXT index. My table is MyISAM based table.
View Replies !
Connection Life
If I establish a connection, how long will that connection live without being used? Is there a parameter somewhere in MySQL that determines this?
View Replies !
Connection To MySQL Using .net
I am trying to connect to a MySQL database, using the .Net framework. I installed the newest MyODCB (3.51) and the .Net ODBC drivers from Microsoft. I made a System DSN using the driver, and i get it to connect - so far so good. But if i try making a new connection i my code using the sample connectionstring from MySQL, i get an Exception :( "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'." What i try is: Return New OleDb.OleDbCommand("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=bigshop;UID=root ;PASSWORD=;OPTION=3;")
View Replies !
Remote SQL Connection
I am trying to access my database on the server with a MYSQL front-end client on my computer (not the server). I have the correct username, password and database name. I tried every possible hostname, even its ip addy, but each time, I am rejected by the server, which says something like - access denied. I can access the database in my php code with 'localhost', but that's of course because the code is actually running on the server. Is there anything I have to specify on the MYSQL server in order to gain access to it remotely?
View Replies !
No Connection Error
When I connect to the MySQL server (4.0.16 on Linux) using mysql and let the tool sit for a couple of minutes, I get the following error. mysql> use mysql; No connection. Trying to reconnect... Connection id: 50791 Current database: *** NONE *** Database changed mysql> use mysql; Database changed mysql> The Java programs are displaying a similar error --> "java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null" No errors in the MySQL logs. The max_connections are set to 1000. Why am I losing my connection to the database? How can this be fixed?
View Replies !
Connection Via MySQLCC
i've a db on my PC. It has 192.168.50.195 IP. It has a user, named amministrazione, who can select records in this db. If i launch mysqlCC as amministrazione to localhost, i can access to db. If i launch mysqlCC as amministrazione to my IP, i can't access to db. ERROR 2003: Can't connect to MySQL server on '192.168.50.195' (10061) PS in my my.cnf there is not "skip-networking" option PS in my grant table i've amministrazione@% user who can select on db.
View Replies !
Connection / Permission
I have the following sitution... MySQL version 3.23.47 PHP version 4.3.2 Redhat Linux version 7.1 Apache version 1.3.29 I have a MySQL user called 'user' that is set up with full rights for localhost, 127.0.0.1, and the external IP address. I can connect to the database using all three users from the command line... ../mysql --user=user --password=password --host=###.###.##.### ../mysql --user=user --password=password --host=127.0.0.1 ../mysql --user=user --password=password --host=localhost But in my php script running on the server, I can only connect using the hostname localhost... $DBConnection = mysql_connect("localhost","user","password"); the IP addresses don't work... $DBConnection = mysql_connect("###.###.##.###","user","password"); $DBConnection = mysql_connect("127.0.0.1","user","password"); these give me the following error: Warning: mysql_connect(): Can't connect to MySQL server on 'domain.com' (111) Is there anyone that's seen this and can point me in the right direction?
View Replies !
LOSING CONNECTION
If I do a the following using mysql_query SELECT * FROM cine_ticket_transaction WHERE performance_day='2004-10-28' AND film_name='Les miserable' If the record does not exist, I lose the connection with the mysql server.
View Replies !
Connection Errors
i was trying to get on a website and this is what came up..... warning: msql_connectO#HYoooHost'bluefin' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' in /siv/www/website/online/online.hyml on line 8 connection
View Replies !
Connection Fail
windows 98 apache 1.3 php4 mysql ....had it all running and could use php with mysql and everything......used it today and cant for the life of me get mysql working.i do the following:- c:Windows> cd c:mysqlin c:mysqlin> mysqld c:mysqlin>mysql -u root -p enter password: ******* ERROR 2003: cant connect to MySql on server 'localhost' (10061) Can anyone see where i am going wrong please?
View Replies !
Connection To The Host
I'm a comeplete MySQL noob, I can't seem to connect to MySQL through telnet. I don't know why I can't connect. BTW, the white boxes are covering my IP.
View Replies !
Dreamweaver Connection
i try to connect mysql in dreamweaver. But I got a error saying that "a unidentifed error occured"what will mostly cause of the problem? how do I fix it?i am using localhost as my mysql server.it works well with sqlyog and DBdesigner with current setup. I can write php with dreamweaver using current setup too.
View Replies !
|
TRACKER
