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 Complete Forum Thread with Replies
Related Forum Messages:
Command Line Client On Hosted Website
My organization's website is hosted by web.com. I am trying to use MySQL to create databases and use them for our website but when I open up MySQL's command line client, it prompts me for the password that I chose when I configured everything and then the prompt is "mysql>" instead of "shell>" and when I type in "mysql -h <ip address> -u <username> -p" it gives me "ERROR 1074 <42000>" How do I use MySQL Command Line Client for a server located elsewhere instead of it just going to the server on my computer? How do I connect to a webhost's server?
View Replies !
Accessing Remotely Hosted Database (ODBC)
I am developing an IVR application and will host it in-house. The application will need to access MySQL database which is hosted remotely in a web server. How could I access remote MySQL database using ODBC? Does the web server have to support SSH?
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 !
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 !
Creating A Website Forum: Use Existing Website MySQL Db Or Create A Second Db?
I am getting ready to start coding my own forum.... to seemlessly integrate it into my existing website. My question is this; should I: a) create the new forum tables in my existing database (used for the website user accounts etc.), OR b) create the new forum tables in a separate new database (it would be on the same server with same u/n p/w) Which one is the better option? I've been banging my head over trying to decide which way to go...
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 !
Hosted Mysql User Access
I have mysql, php and apache all hosted and am trying to use phpmyadmin to connect to the database however I get a user access problem, it says access denied.
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 !
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 !
MySQL And Shared Storage
--=_D38DA341.B3D2A80A Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I would like to set up a round robin cluster with mysql. The round robin = would be done through the DNS to two different servers. Each of those = servers would have mysql installed and each would reference the same data = directory on our SAN. Are there any problems with doing this? =20
View Replies !
MySQL-shared RPM Install
I'm having problems installing the shaired libraries. This RPM came from the MySQL.com download site. [root@localhost src]# rpm -i MySQL-shared-4.0.17-0.i386.rpm warning: MySQL-shared-4.0.17-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
Hosted Sync
I have 2 mysql database, the first is mysql from hosting company and the second is mysql hosted on my computer. What i have to do to syncronizing both database.
View Replies !
MySQL On A Website
I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL.
View Replies !
HOW DO I USE MYSQL WITH MY WEBSITE?
I have an existing website with Netfirms and it comes with "mysql" "php" etc. It is active and have been able to confirm that with tech support. I purchased two books regarding "php & mysql for dummies" and "biginning php5,Apache, mysql Web development" and still I donot have a clear understanding of how to write a script that will allow a website user to interact and or collect information and display information on the website page. I mean this is what it is all about right? Can someone please just give me an example that I can follow on how to actually creat a script to allow mysql to interact with a webpage. And while your add it. whats a good learning tool, book etc to have?
View Replies !
MySQL Driven Website
I would like to do is create a website that is driven by a MySQL database. The question is, does MySQL have to be installed on the web server by my isp or is there another option. I have read some posts about a MySQL DLL that can be placed on the server instead of a full install, but have not found enough relevent info.
View Replies !
Connect To Mysql From A Different Website?
I have 2 websites that sometimes I want to transfer products from one website to the other. An easy way for me to do this would be site-a connect to site-b DB, select the data, and then reconnect to own site-a DB and save. I dont think security risks would be a big issue because the only thing I would be transfering would be products which dont have any sensitive info connected to them. but is there a way? if not I will just have to do it manually...Im just trying to be sufficient.
View Replies !
Displaying MySQL Data On Website
Currently, our neighborhood directory is in Microsoft Access, and every few years we would have it printed professionally and bound. I have Reports which formats the data for the printed directory. I would like to add the directory to the website, to replace printing it. I can easily create the tables and insert the data. I'm not sure how to go about displaying the directory data. Is there is a way to create a report and display that? Each entry represents a family in the neighborhood, but the fields that contain data may vary from family to family, such as the kids field. Also, I want multiple entries on a page - like a phone book.
View Replies !
Root User And Developing PHP/MySql WebSite
my webhosting company defaulted a root user with no password. I created a user for myself with a password, but wondering if having the root user without a password will leave the database open to intrusion. What's it there for, anyways? On another note, what is a good IDE for developing a PHP/MySQL website that will be served from a UNIX server, but developed on a windows PC?
View Replies !
Using MySQL For Website Database Backup / Restor
so apparently MySQL is widely used for web site backup's of databases.....however i cant seem to figure out how that is supposed to work. i am using joomla, and i have a couple ways of makeing .sql backups, but im not sure how i am to put the database on again, or if need be, on a second website. am i making sence? i need a way to "import" my database to a website incase it gets 'nuked' or something. is MySQL the right program for this, or not?
View Replies !
MySQL Versioning Of PHP Data-driven Website
I have a website that I am designing that uses a bunch of PHP scripts to generate pages for a website from data stored in an underlying MySQL database. I have the PHP scripts under CVS, and using Apache and mod_rewrite I am able to access different versions of the website from the CVS project - each with their own set of PHP scripts. The problem is this: I would like to version the MySQL database as well. This means that there would be multiple MySQL databases, with slightly varying schemas on the server. Each PHP version of the website would point to a corresponding MySQL database for its data. Multiple PHP versions could point to the same DB, as long as each PHP version has SQL statements matching the schema of the correspoinding DB. One version of the DB would be a live version of the site (v1 for example, above). Users accessing the site would causes changes to the data in the DB (not the schema, of course). The second version of the DB (v2) would need to basically be a slave replication server, using DB v1 as the master. This will allow DB v2 to be up-to-date with all of the user updates that appear in DV v1. DB v2 is the development copy. As the design matures, schema changes will be made to DB v2. At some point, DB v2 will be made the "live" server, essentially taking the role of DB v1. As long as fields are only added to tables in DB v2 to modify the schema, the developer can easily just feed the updates from DB v1 to v2, to keep the user data current. The complicated part is when schema changes need to be made to v2 where fields are deleted, renamed, moved, etc. What is needed, basically, is a system that can track the ALTER TABLE statements, and appropriately translate the UPDATE statements from DB v1 to the new schema of DB v2. The developer could specify non-obvious and more complicated changes in some sort of syntax in order to clarify the changes to the underlying schema - thus allowing the generation of the proper relational algebraic (SQL) statements from the original UPDATE statements. Does anyone know of an existing system or set of scripts that accomplishes this, or can offer an alternative solution for DB versioning?
View Replies !
Install Using Book :: Database Driven Website Using PHP And MySql
I've just purchased copy of "Database Driven Website Using PHP and MySql" and have a few problems getting started. I had tried to install apache via the manual install but could'nt make any sence of it. I them found a program called Xampp. I installed it becuase it included PHP, MySQL and would get apache working as well. Having read the first part of the book I did'nt think I needed to install any programs and tried to start on Ch 2. I can't open the msql.exe file or even find it??
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 !
UDF Shared Library
I am trying to create a User Defined Function (UDF) using mySql 4.1.11 (mysql-max-4.1.11 for Solaris 8). I am trying to get the examples to work (udf_example.so) I have successfully compiled it and copied the resulting .so file to /usr/lib. The command 'crle' (like ldconfig on Linux) shows that /usr/lib is in the library path, but when I type in mysql: CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so" I get the error 1126, Can't open shared library 'udfexample.so' I've tries renaming the library 'libudf_example.so', but that didn't work either. I don't know how to check what libraries mysql is looking through. I am just guessing that it uses the library path from 'crle'. Any ideas?
View Replies !
Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool. Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?
View Replies !
Replication Using A Shared Fileserver
I thought of a radical way to do replication of MySQL servers. Let's assume two MySQl servers access a shared mapped storage (/mnt/db) which is a local mount to a fileserver on the network. This fileserver is shared between the MySQL servers; which means any writes to /mnt/db appears immediately on /mnt/db on the other MySQL machine. Two MySQL servers may attempt to modify to the same file if we don't use synchronization. My question is, first, can we do this without making patches to MySQL code, and somehow using some synchronization mechanism accross the two machines running MySQL server each. Or we need to patch MySQL code to support such architecture. Second, is it trivial or impossible to do, how much man-time it requires roughly.
View Replies !
Connections On Shared Server
I frequently get the error message: Warning: mysql_connect(): User user1 has already more than 'max_user_connections' active connections in /home/.sites/60/site23/web/Connections/mysite.php on line 9 It's commercial web hosting on a shared server so I have no control over the server side of things. The php scripting has been written using the GUI in Dreamweaver. Is there anything I can do to resolve this? Should I be using mysql_connect or mysql_pconnect, or is this not the problem? Do I need to include somewhere in my scripts a snippet which disconnects from the server? If so where would I put this? I am not all that familiar with php and mySQL, though I understand parts of it when looking at the code. The database connection is made via a connection.php file produced by Dreamweaver which includes the database details etc. My max connections are only 10. Is this the issue? It only seems to appear when I use php to edit or add to the mySQL database.
View Replies !
Find Shared Values
Say I have a one long Table of people and the foods they like. How do I find all the foods that are like by both of two particular people? ie David peas Kate sausages Kate eggs Bill eggs Kate peas Fred sausages Fred peas and i want to find out what both Fred and Fate like:
View Replies !
How To Find Out Values Shared By Some Members
I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. Code:....
View Replies !
Shared Column Data Transfer
I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1. select * from tbl1, tbl2 where tbl1.column = tbl2.column; Above query gives me the results that need to be updated. What will the update statement look like?
View Replies !
Multiple Database, 1 Shared Table, Is It Possible?
I Used MySQL for a long time dev under PHP 3, 4 and now 5 now i'm facing a problems that i solved in the past with php, but i wonder if MySQL could do it on it's own, that'll help me a lot. Multiple database, 1 shared table, is it possible? i mean, i already done with 5 install of Xoops CMS and modified it that every install is on the same database, with deifferents prefixes (like db1_ db2_ ...) then i mod Xoops for each time it called for it's users or saved open sessions id in the DB it use the same table on all install... so the users seamlessly wonder about in 5 differents xoops install without disconnect and change username. now i face the same problem, i need a multi-install or a single install of a core system that will act as a multi-install sofware, but with the same set of users, sessions and some other things.
View Replies !
|
TRACKER
