How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states
and other countries on the other side of my router. But when I use the
MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN,
the driver tells me it cannot make the connection. Here are the ODBC
driver connection parms:
Data Source Name: (free field - name my "my linux box" will do nicely)
Host/Server Name (or IP) - something like MSQLUserName@ServerName.net
has worked fine for me in the past. Now I'm trying 192.168.1.106
Database Name - whatever, mysqldb works fine, any valid db
User - root
Password - myrootpass
Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now
SQL Command On Connect - haven't ever put anything here
Perhaps there is some configuration in mysql user privilege for the
mysqluser "root" that would prevent him from logging from a remote PC
to the mysql server?
View Complete Forum Thread with Replies
Related Forum Messages:
Configure MySQL ODBC Driver
I'm working on a MFC application and I need to be able to prompt the window "MySQL ODBC 3.51 Driver - DSN Configuration" for the user to configure a dsn connection... This is like selecting the "ODBC Data Source Administrator", selecting the File DSN tab, clicking one of the dsn links and then pressing configure... Is there a way to prompt this precise window programmatically?
View Replies !
Can I Use Asp And ODBC Driver To Connect To MySql Database
I just migrated my access db to mysql and I'm trying to figure out how change my connections and code for mysql, I was told that I would have to use php, but I also read that it can be done with asp using an ODBC driver which I have installed on my server. If I use the ODBC driver would I be able use the same SQL that I used to connect to the access DB? what other issues would there be?
View Replies !
[MySQL][ODBC 3.51 Driver][mysqld-5.0.19-log]MySQL Server Has Gone Away
My site is hosted on Windows IIS, and I use ASP, and connect to MySQL 5.0.19 via an ODBC 3.51 driver. MySQL is I think hosted on a Linux machine. My problem is this: My site keeps getting lots of these errors messages each day: [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-log]MySQL server has gone away I mean hundreds - e.g. for Feb alone, so far, these errors have been logged in my error table:
View Replies !
Can Connect Mysql Database Through Router?
i have already used mysql server with many application done for testing for personal purposes, but i have found a issue that i cannot solve yet. I installed a mysql server in a computer far away from where I stand, the thing is the ip address of this computer is given by a router and it is impossible to me to make a good communication to that server. Is there any application, software o a possible way that i can communicate to this server?.
View Replies !
ODBC Driver Setup - Don't Prompt On Connect
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 Can't Connect To MySQL Server On 'localhost' (10013) (2003; S1000)
I have xampp running. WinMySqlAdmin is correctly showing my database "finofix". Using dosbox i can open the database using "mysql -ufinofix -p<pwd>;" and "use test;" So everything looks allright. My application runs on 'localhost'. ODBC sytem-DSN definition: name=finofix, server= ,username=finofix, pwd=XXX, database=finofix When running my PHP application I get: msql,version 32.1.739,Nov 15 2000 ODBC: available data sources: ODBC: finofix - MySQL ODBC 3.51 Driver ODBC: database connect string is 'finofix/finofix/<password>' ODBC: connecting to database ODBC Error: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10013) (2003; S1000)
View Replies !
MySQL Server IP Wrong After Getting New Router
My router died a few days ago and I bought a new router to replace it. Installed the new router, everything works properly only diffrence is my private IP. I went from a USRobotics to a LinkSys so my IP changed. I get this error when I try to get on my forum I have setup. The error has my old IP address in it that its looking for (192.168.123.108) My new IP is (192.168.1.101). Is that part of the problem and how do I change this? Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.168.123.108' (10060) in C:wwwphpBB2dbmysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:wwwphpBB2dbmysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:wwwphpBB2dbmysql4.php on line 331 phpBB : Critical Error Could not connect to the database Edited 1 time(s). Last edit at 09/26/2006 09:48AM by littleman2030.
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 !
MySQL ODBC 3.51 Driver Very Slow!
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally.
View Replies !
MySQL ODBC Driver In DataLink
I'm trying to use the Windows DataLink (udl) to set up a connection to a MySQL database. I've installed the 3.51 ODBC driver from the MySQL website - however, using a DataLink, it doesn't show up as a DataSource - How can I get it recognized there?
View Replies !
MySQL ODBC Driver Error
I am using C# to edit and view a MySQL database. I have added the ODBC driver for MySQL to my computer and I can add the database to my project in Visual Studio. At first it gives me an error and I have looked in other forums and found that there are two periods were their should only be one and I have since corrected this by editing the statementment in the designview with... SELECT * FROM `mu`.`environment` instead of SELECT * FROM `mu`..`environment` At this point when I click finish, VS2005 says there were errors generated with the tableadapter configuration, specifically the SELECT statement. ERROR [HY010][MySQL][ODBC 3.51 Driver][mysqld-5.0.26-community-nt] If I continue anyways I can preview the data just fine, however if I add a datagridview to my form it is blank. In the design view, it is not displaying any of columns. It is like the columns don't exist. What am I doing wrong? Also, I see there is a ADO.NET driver for MySQL, would that work better and if so how can I add the database to my project.
View Replies !
Performance On MySQL 5.1 / ODBC 5.1.4 Driver
Following procedure needs about 25 sec. to find the record I am asking for: Private Sub btnLesen_Click() sSQL = "SELECT * FROM tblAdressen WHERE AdressNr = 8" aRs.CursorLocation = adUseClient aRs.Open sSQL, oConn, adOpenKeyset, adLockOptimistic If aRs.RecordCount > 0 Then sevVorname = aRs!Vorname sevStrasse = aRs!Strasse sevOrt = aRs!Ort sevName = aRs!Nachname End If End Sub There are around 14'000 records in the table, Nr. 8 is the first one! I am trying to find the reason for the bad performance for days - without any success. Following Flags are checked for the connector: - return matched rows instead of affected rows - Allow big results - Use compression - Treat BIGINT columns as INT columns - Enable safe options - Don't prompt when connecting - Enable dynamic cursors - Ignore schema in Column specification - disable driver-provided cursor support - Don't use setlocale() - Don't cach results of forward-only cursors - Ingnore space after function names - Disable catalog support - Disable transaction support - Force use of forward-only cursors - Limit column sizs to signed 32-bit range The file "my.ini" I didn't change! I work with Win2000 & VB 6.0
View Replies !
Configure And Connect Mysql
I am in process of learning and equip myself with Java technology.The problem encountered is to connect and configure mysql with jdbc in windows environment. How to set the driver manager?where to set it?I am now quite blur and confused..I try to type 'mysql' MS DOS but there is an error stated "can't connect My Sql in localhost".
View Replies !
SQLColumns Function And MySQL ODBC Driver
The MySQL ODBC driver returns an error when calling SQLColumns function with an empty Table parameter: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Can't use wildcards in table name Is there a newer version which supports wildcards in table name? Actually I don't really need wildcards, but I need to get the list of all columns in all tables.
View Replies !
MySQL A Server-Side Technology
I have a MySQL database and php scripts on a Linux server. When I do simple DB connects, queries and results in MSIE 6.0.SP2 everything runs perfectly. Yet when I access the same exact HTML Page in Firefox 1.0.1 I get absolutely no results. When I hit the same page in Netscape 7.2, sometimes I get the results to appear and sometimes I don't. Isn't MySQL a server tool that has nothing to do with the browser?
View Replies !
URGENT: Error 1316 On Install Of MySQL Connector/ODBC Driver 3.51
I have my Vice President's laptop and trying to install the ODBC drivers for reporting that he needs.. and am facing a time crunch. I'm getting the following error, which I've never run into before. I thought the setup file was corrupt, so I re-downloaded her from another mirror, but I get the same error. ERROR 1316. A network error occurred while attempting to read from the file C:DOCUME~1cbockLOCALS~1Tempmysql-connect or -odbc-3.51.12-win32.msi
View Replies !
Going From Client Side, To Server Side.
I was wondering: if i install MySQL, and the PhP egine on my computer, does this mean, i will have to connect my domain name, or URL, to my machine? I am having a hard time figuring out in my head the process by which i go from having something on the client side end of things, and the server/host side of things. I know that PHP is pretty much a language that you basically have as files, much like an actual HTML page. To this end then, i realise i will simply have to load my PHP scripts onto the server in which they are supposed to work. I am not however sure how i would do the same with MySQL. I do not know enough about the latter to know how its transferrable. So far, from what i read, i use a Console to test certain commands, like the creation of a Table, or the deletion of a Table. But how do i actually connect MySQL to a server that is not my own machine?
View Replies !
ODBC To Connect Mysql
I would link to use VB to connect mysql using ODBC, but the mysql database is outside my OS. I'm sure that the setting of ODBC is done, but when I connect the ODBC, it prompt me the error message " Host 192.168.xxx.xxx is not allow to connect to mySQL server" What wrong with it?
View Replies !
Control Center Connect Network/router
I can access my MySQL database with MySQL Control Center from a computer with a direct connection to the internet, but I can't do it from my other computer on a network. Is there a way to use MySQL Command Center through a network/router? I'm unable to find any connection settings options in the program.
View Replies !
Create Odbc Connect From Mysql To Oracle
can someone provide step by step instructions on how to set up a odbc connection from mysql to oracle and have records in a table transferred from a mysql table to an oracle table. Mysql and Oracle are on Solaris OS.
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
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 Setup On MySql Server 5.0
I've installed the MySql server 5.0 successfully, opened and verified it working (the instance is running, i've used the server window to login and used a few commands in it). I've also installed the MySql Query broswer along with the 5.1 odbc driver. However intalling the driver didn't populate a User DSN and I've no idea how to add it myself i.e. the settings! The driver is present in the driver tab.......
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
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 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 !
ODBC Driver Problem
I was successfully loading a table from ACCESS up to my host MySQL using the 3.51 ODBC driver. Then I upgraded my Windows 2000 sp3 to sp4 (and I think Microsoft updated Office at that time as well along with doing some security fixes.) Now Windows and ACCESS work, but I when transferrirng I get: "ODBC - call failed [MySQL][OBDC 3.51 Driver] User cancelled (#0)" or "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience." Any clue as to what's calling this? I though about re-installing Access, but it looks like you have to re-install the whole Office if I do. I tried a repair on Access and also re-installed the dirver. No change.
View Replies !
Retrieving Data From Non-MySQL Server Via ODBC
I'm investigating using MySQL instead of the dreaded Access to retrieve logged information from a process control system. Is there a way to use ODBC to get rows INTO MySQL? All I can find in the manual is how to set up MySQL as an ODBC server for other applications. The control system is configured as an ODBC server, and Access will connect to it, but hangs and dies when I try to retrieve data.
View Replies !
ODBC Driver Does Not Support The Requested Properties
I'm trying to log data to a certain schema on MySQL 5 server via DSN. MySQL connector/ODBC driver version is 3.51., running in Win XP. *Sometimes* I receive the following error: --- An error occurred calling 'LogResults' in 'DBLog' of 'DBLog 1.0 Type Library' An error occurred executing a statement. Schema: My Recordset. Statement: My_Table. ODBC driver does not support the requested properties. Description: ODBC driver does not support the requested properties. Number: -2147217887 NativeError: 0 SQLState: Reported by: Microsoft OLE DB Provider for ODBC Drivers Source: DBLog --- The worst thing is that sometimes everything seem to be ok but no data is logged to database! This case is very confusing, the logging has been successfull before and I've not been able to trace this. I've checked the basics (SQL syntax, schema priviledges, ...).
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling from source. When I try to run MySQL, I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' After much searching on Google, and reading many newsgroup threads on this error, as well as reading the manual, I'm still stumped. Most of the advice I've found suggests that the path to mysql.sock is wrong, which makes sense, but I don't have the file mysql.sock anywhere on my machine, so obviously I can't correct the path.
View Replies !
MySQL-error : Can't Connect To Local Mysql Server Through Socket
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin):: #2002 Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock On the website of MySQL this error is mentioned but I found no solution. In /var/log/messages the following log occurs : localhost kernel: audit(....): avc: denied {write}for pid=2458 exe=/usr/sbin/httpd name=mysql.sock dev=hda13 ... What I have tried : - mysql.sock is srwxrwxrwx, seems ok, but dont know what the s stands for - the dir /var/lib/mysql was drwxr-xr-x and I changed it to drwxrwxrwx : no effect - tried different version of phpMyAdmin : same error - installed my website and got the following error : No connection possible with database (in the next version I will improve the error-messages) - through commandline there is no problem in connecting to mysql (log in, create databases, inserts, deletes, uploading dumps, making dumps, ....) What is the solution or what else can I try ?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I am using a Mac running Mac OS X 10.4.8 and I have successfully installed MySQL on it but when I go to run it using the command sudo ./bin/mysqld_safe & all it does is display a random dumber and when I try the command ./bin/mysqlshow -u root -p I get an error message saying Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
Server Side Question
i have created a php based website and have created a user/password form. I also have created the database to connect to this form. I upload all data and info to my webserver, but when i go to do the test it tells me it cannot connect to MySQL database. Do i need a server side version of mysql to make this work or is it something i could be coding wrong?
View Replies !
|
TRACKER
