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 Complete Forum Thread with Replies
Related Forum Messages:
ODBC Not Setup, Connects Without Password
I've searched for a while now and found many people with the exact opposite of my current issue, When I connect to mysql without specifying a username, it automatically connects as odbc@localhost, and does so without asking for a password. That would make sense to me, but I have not setup or configured ODBC in my Administrative options (using Windows XP) so I'm unable to find anywhere to disable and/or set a password for ODBC. I can connect using the root account, and it asks for a password, and works correctly. I've checked my .ini files and don't see this referenced anywhere.
View Replies !
Access Denied For User 'ODBC'@'localhost' (using Password: NO)
I am having a problem connecting to mysql from php. Here is my code: <html><body> <? mysql_pconnect("localhost", "root", "password"); mysql_select_db("lead"); $query = "select * from products"; $res = mysql_query($query); if($res === false){ print "Error: $query<br>" . mysql_error() . "<br> "; exit(0); } while($row = mysql_fetcharray($res)){ print "$row[0]<br> "; } ?> </body></html> I've read somewhere that this is a known issue and that you could down grade to fix it, but I couldn't find anymore information than that. What needs to be downgraded, and to what version? Mysql 4.1.5, Apache2, Win 2000, php 5.0.1.
View Replies !
Access Denied For User: 'ODBC@localhost' (Using Password: NO)
im having a problem DELETING rows from one of my tables in PHP. i make various calls to mysql_query, and the script works fine until i add the following line: mysql_query("DELETE FROM {$GLOBALS['TABLES_SEARCH_Page']}"); i have given the user DELETE privilidges, but despite this, i am always returned the error: Warning: mysql_query() [function.mysql-query]: Access denied for user: 'ODBC@localhost' (Using password: NO) in g:wwwResourcesphpSearch.php on line 142 any ideas?
View Replies !
Error Access Denied For User 'ODBC'@'localhost' (using Password: NO)
I know this has been posted repeatedly but I have yet to see a response that works for me. When I created my server I did NOT create a root userid and password and it is started as a service on Windows XP. Why does it want one? I try to run this command and get the error for testing it: "C:Program FilesMySQLMySQL Server 5.0inmysqlshow" Response is the subject title.
View Replies !
Unable To Connect To Database :: Odbc.ini Or The Odbc.inf
We are using MySQL on Linux server and "NetCOBOL V7.0L10" to access our MySQL database. Our Linux ODBC driver description is "MyODBC 2.50 Driver DSN". When trying to establish a connection to the database, we receive an SQLSTATE value of "S00?M" where "?" changes with each execution. The SQLCODE value is always 00000104 and the SQLMSG is always "[nxDC[C]MOB]cesdne o sr sxlclot Uigpswr:YS". We suspect that there is something wrong with either the odbc.ini or the odbc.inf file definitions but can't quite determine what the error is.
View Replies !
ODBC Connection :: ODBC -- Call Failed
I am trying to connect to a MySQL database on our Linux Server using MS Access on a Windows 2000 machine and MySQL ODBC drivers. Each time I try to connect I get the following error: ***************************** ODBC --call failed. [TCX][MyODBC]Host 'du-069-0221.access.clara.net' is not allowed to connect to this MySQL server (#1130) *****************************
View Replies !
Random Password Vs. User Created Password For Site Login
Are there any security issues or other concerns that make one preferable? The client is pushing for user created passwords. I'm mapping out the basic functionality and front-end for a MySQL/PHP back-end that will be completed by a third party. I'm a novice to MySQL but familiar with PHP and their interaction. Mainly looking for anything to support one method over the other.
View Replies !
Mysql Password() & Unix Crypt Password...
I am creating a user administration system where system administrator can activate services for a user, like webspace, a mail account or a subdomain. I now want to create a function that creates mysql databases and grant the right privileges to a user. But the problem is that mysql wants to have the plaintext password for the user in the "grant ... identified by 'pwd'" field, or in a manual query to update the password in the mysql.user table with PASSWORD('pwd'). I have another database which holds the passwords for the users, these password are stored the moment a user signs up and are used to activate services, for example ssh access to the machine. The stored passwords are encrypted using crypt(). So for adding a ssh service to a user, I simply do echo "$user:$pwdhash" | chpasswd -e. I have chosen crypt because some programs (like proftpd) don't take md5 sums. The problems is that I don't have the plaintext password. So I cannot add a mysql db. So I need to create a user in mysql with a crypt password. I tried to just "grant all privileges ... identified by 'nothing'" and then afterwards update the mysql.user table and putt the crypt password in there but it doesn't work like that. Does anyone have any idea on how I could fix this, how can I create a user in mysql without having his plaintext password and only having a crypt hash of it. I thought about not only storing a crypt hash, but also an md5 hash and a mysql PASSWORD() hash.. but I think that's an ugly solution.
View Replies !
I Can Connect With Db Password Or Blank Password
I have a password setup for root (% and localhost) in Mysql 5.0.26, I can connect ok no problem. I can also connect with blank password! I know it is checking the password cuz it fails if it's wrong. I'm sure I have only one account as well (tried to delete, recreate, etc... no change) select * from user where user='root'; | localhost | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... | % | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... Is there an option to accept blank password!? I have this problem only for root user; Other accounts are fine.
View Replies !
Password :: Change Password
I have trixbox 1.2.3 running and in freePBX it told me I need to change the password in mysql. I went into mysqladmin and privileges. I updated the passwords for a2billinguser and root. Now I am denied from access to mysql and all services that use mysql don't work. How do I restore the default that trixbox used. I have a very large major system here and cannot just blow it away.
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 !
Bookmarks And ODBC
I am porting C code originally written to talk to a SQL Server engine via ODBC. While many of the differences are mainly annoyances, and I found work arounds, I have run across one big issue. The MySql driver (3.51.06) doesn't support bookmarks. The only time this is a real problem is when I need to get the value of an auto-incremented column after an insert.
View Replies !
Delphi And ODBC
I have been an avid MySQL and Perl developer for several years now. I have always used DBI and DBD for perl. Very familiar with this. I have been assigned to write a Delphi application that stores data into a MySQL database. I really have no idea of how to do this and how to access MySQL from within a Delphi application. Can anyone give me some hints and some links to go to so I can learn this? I'm sure it is not hard, but just not sure where to look. I tried googling for it, but links I found were not very informative.
View Replies !
Merge The ODBC
I developed program by vb6 and mysql database.If I would to merge the ODBC of mysql and setup of my program in one file how is it?
View Replies !
MySQL 5.0 And ODBC
Tried the ODBC 5 connector that MySQL provides - it is an Alpha product and is really not ready for prime time. Does anyone know of any 3rd party ODBC connectors - even commercial ones - that are ready for MySQL 5.0 and support the new stpred proc with parameters functionality in MySQL 5?
View Replies !
Odbc Driver
i am using Access 2003 connecting to mysql 4. and newest odbc driver, and i set a checkbox form control bound to a unsigned integer field in my database. if its intially set to 0, or 1. it will be checked in my access form. if i uncheck it, it will update my mysql database accordingly to 0. but if i check an unchcked box, it will not let me do it. it seems to send -1 to the field whoever at microsft made (-1 == yes) should die lol. anyone know a way to make access recognize it, or fix odbc driver so it knows if microsoft uses the driver to convert -1 to 0? my best solution is make a trigger on update, and if that new value is -1 set it to , hoping it wont spit back error back to Access for the inital -1 being wrong. any other ideas? wish i knew what event to override to do my own insertion. if checked, UPDATE with 1, if unchcked, UPDATE with 0.
View Replies !
ODBC Not Support Utf?
my host only gives me ODBC connection to MySQL. i need the table to store some chinese characters and display them to the ASP.NET form. when i tested MySql connector on my dev machine, i added CHARSET=utf8 to the connection string and set the column charset to utf8 and it worked well. i did the same thing while using ODBC 3.51 Driver but all i saw was ????. am i missing anything or ODBC 3.51 Driver simply doesn't support utf?
View Replies !
JSP / Servlets And ODBC
I am trying to create a Data Source Name for MySQL with ODBC and I keep getting an error. I am trying to get servlets to work with JSP and MySQL database. I used PHP before and the database can be accessed fine. The error is: [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Perhaps I am not configuring it correctly? I am using TOMCAT for Apache and so I am entering a localhost on Port 8080... Should the server be 'localhost' with '8080' under Connect Options or 'localhost:8080'? Is a user and password specified somewhere else or can I just make one up there?
View Replies !
ODBC Connnection
i am using a simple MySqlPhp Generator to generate forms all is done well however when i run the file which is generated this comes up Access denied for user 'ODBC'@'localhost' (using password: NO) and to solve this problem all i did was take out the root password from my database and connect without the password all works fine if i do that however i want set a password to my database but when i do that the error message comes up "Access denied for user 'ODBC'@'localhost' (using password: NO)" how do i solve this? i am using mysql 4.1 apache 2.0.59 php 4.47
View Replies !
ODBC Connectivity
I downloaded the MySql ODBC driver and have tried to create a System DSN...I get this error if point to IP or domain name: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysqlname.mydomainname.com' (11004)
View Replies !
ODBC Connector
I need it for using the ODBC connector. How can I found out what it is? Is there a PERL script or PHP that I can use to get the actual hostname? Can they "disable" access to it via its URL or something?
View Replies !
ODBC CONNECTIONS
We are in the process of setting up a database to house some information from our (legacy) ERP. Two questions have arisen: 1. Can we create a direct link to the data source from the db? 2. Currently we are using access as an intermediate connection - the link to the dsn in in access and then we have been exporting the data to the MySQL table. However, this will not let us update the tables it creates because it says the file already exists. If we stay with this method, how do we update the tables on a nightly basis (needs to be an automatic function).
View Replies !
ODBC Message
I have a mysql 3.23.49. It's working on Linux Red Hat, all our application run in Windows XP connecting through ODBC driver. We've been receiving some warning messages recently, but that application run more than 3 years and we'd never received that message: Warning: Lost connection to MySQL server during query The computer has 4 cpu (1.5Mhz), 2G RAM and free space in Hard Disk, it's only database server. Where can I start analize from? The top command, most of time show mysql working with 100% cpu.
View Replies !
Odbc Drivers: WTF?
In winmysql admin, I was getting errors that it couldn't find drivers for odbc 3.51. Although I can't understand why it isn't included with the mysql package, I found odbc, and installed it. Now I get this error: not found Driver Version driver C://Windows/System32/myodbc3.dll API Level Setup C://Windows/System32/myodbc3s.dll SQL Level
View Replies !
Using MySQL From ADO.NET And ASP.NET Via ODBC
I have the following problem when I try and connect to MySQL - REGDB_E_CLASSNOTREG(0x80040154) - (MySQL ODBC 3.51 Driver). I have used this driver via VB6 using ADO and ODBC without a problem. The connection string I'm using in ASP.NET and using .NET Framework 1.1 and MDAC 2.8 RTM is: MyConnectionString = "Provider=(MySQL ODBC 3.51 Driver);Data Source=localhost;uid=;initial catalog=property;password="
View Replies !
ODBC Error In V5
I am using ODBCv5 but when I run: [code].... There is an error "ODBC DRIVER does not support the requested properties". I am using Visual basic 6 running in windows professional with sp2.
View Replies !
ODBC Commercial Use ...
I can't post any messages @ the Licensing-Forum, so I have to ask here oO . So I want to create a Software and sell it. Do i need to buy a license if i'm just using ODBC and not really MySQL it's self?
View Replies !
ODBC Or DDE Link Help
I have a MYSQL database and use PHP to query it as well as display web pages. I have a third party application which has fields I can copy and paste into an excel spreadsheet and using DDE links the excel cells automatically update when refreshed. I would like to apply the same theory to MYSQL or PHP instead of Excel. When a web page is refreshed it queries the third party application and gives updated values, or maybe some way to update a MYSQL table with the data. I have looked up ODBC connectivity, OLE Links and DDE links. I can see that it is possible to have Excel or Access query MYSQL but not sure if MYSQL or PHP can query the third party app.
View Replies !
ODBC Setup
I have a Windows 2000 Server preinstalled with mySql, and have tried to run a basic connection test though the ODBC manager for the mySql Server Driver, and it continues to say it can not find mySQL. When setting up a standard database through the ODBC Manager, here is the basic info it provides. Code:
View Replies !
ODBC: Login
This is kind off topic how to connect to ODBC. <?php $server = "real_dsn_server:3180"; $user = "root"; $password = "admin4"; $dbnameID="info";?> <?php $conn=odbc_connect($server, $user, $password); $sql="SELECT * FROM $dbnameID"; $result=odbc_exec($conn,$sql); echo "SUCCESS";?> I got the following error: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in odbc_log.php on line 10 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in odbc_log.php on line 12 SUCCESS Why is that? Even though I can DSN in control Panel>ODBC on windows XP Pro and it said successfully.
View Replies !
Win XP Missing MySQL ODBC 3.51
Windows XP sp2, Installed MyODBC 3.51 and the driver. It does not appear in the User/System DSN ODBC control panel. Does not appear in the driver tab Is listed in the ODBCINST.INI and appears in the registry REGEDIT4 Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMySQ L ODBC 3.51 Driver] "UsageCount"=dword:0000000c "Driver"="C:WINDOWSsystem32myodbc3.dll" "Setup"="C:WINDOWSsystem32myodbc3S.dll" "APILevel"="2" "ConnectFunctions"="YYN"
View Replies !
ODBC Connection Using Access
I am using Access 2K as a front end to MySQL running on a Linux server. I am having trouble connectiong to the server. MySQL control centre connects and I can connect using a DSN data source. But if I connect using the following code: Dim constr As String Dim tbl As DAO.TableDef constr = "ODBC;DRIVER={MySQL ODBC 3.51 Driver};DESC=;USER=" & SQLServerUser _ & ";DATABASE=" & SQLServerDatabase _ & ";SERVER=" & SQLServer _ & ";PASSWORD=" & SQLServerPassword _ & ";PORT=;OPTION=;STMT=;;TABLE=" & MYTABLENAME tbl.Connect = constr tbl.SourceTableName = MYTABLENAME DoEvents CurrentDb.TableDefs.Append tbl I get a Cannot find installable ISAM error message when trying to append the table. It appears that a connection is made but that I cannot access any of the tables. I have tried using other connection methods and get the same results. If I change the above to constr = "DSN=MYDSNCONNECTION;DESC=;USER=" & SQLServerUser _ & ";DATABASE=" & SQLServerDatabase _ & ";SERVER=" & SQLServer _ & ";PASSWORD=" & SQLServerPassword _ & ";PORT=;OPTION=;STMT=;;TABLE=" & MYTABLENAME Where MYDSNCONNECTION is the DSN connection set up in the data sources, the code works and the table is appended.
View Replies !
ODBC Version Trouble Between 3.51.10.00 And 3.51.11.00
we are dealing with some very specific problems with ODBC, where a connection from SQL-Server to Mysql works with ODBC-driver 3.51.10.00 and does NOT work with ODBC-driver 3.51.11.00. Maybe someone experiences similar problems or even has a solution ? We use a Microsoft SQL-Server as Headquarter database and some Mysql-machines on Redhat as satellite-databases. We use a script to copy and replicate data between satellite and headquarter. This script is using simple SQL connecting to Mysql-database using ODBC and "Openrowset". In order to copy only new data from sattelites we use the Binary_Checksum function from Microsoft SQL-Server. This works with the 3.51.10.00 version perfectly but it fails with the 3.51.11.00 version, where it gives us the message (from MS-SQL-Server) "msg 8481 Error expanding "*": all columns incomparable, '*' expanded to zero columns". This message comes only for some but not for all statements using the binary_checksum. The only way to fix this is to stick with the "old" version of the ODBC-driver. Could someone please explain what is going one?
View Replies !
Making ODBC Work
When trying to set up programs (dbQwikSite, Adobe Designer) to work with ODBC databases, I encounter the following during setup of the programs: "it connects, but if I set the initial catalog to any database it says: "Test connection failed because of an error initializing provider. Catastrophic Failure." But when I connect with the initial catalog field empty it connects successfully.How do I fix this problem?
View Replies !
Mysql Access Through ODBC
I have a Mysql table which has over 40000 records. If i want to access from VB using ODBC connection. will that be good choice related to performance wise. or any other options there.
View Replies !
User Permission And ODBC
I am using SQLyog. I want to manage user permissions down to a field level which SQLyog does. Any DDL or DML statements that I attempt to execute within SQLyog support the defined user permissions. However, when I use MySQLCC the persmissions are totally ignored. This is also true when I attempt to access the database through ODBC using a number of third-party tools. My intent is to offer my clients the ability to access their data through ODBC with the option to restrict a specific set of users to sensitive data (Financials or salary amount column for Payroll) using a tool such as SQLyog. Is this possible that one tool has the permission and another not?
View Replies !
ODBC Driver Setup
I have setup an ODBC driver for my MySQL database and use a 3rd party program to connect to it. Everytime the software connects, the ODBC driver setup screen pops up. I have to click OK on it to continue. I set the parameter "Dont prompt on connect" in the options but this has not solved the issue. The system setup is Win2K SP2, MySQL 4.0.15, MySQL ODBC driver 3.51.
View Replies !
ODBC Client Problems
I've just installed 4.1.0-alpha-max-nt onto my server and now my 3.51 ODBC client says Client does not support authentication protocol requested by server. Consider upgrading MYSQL client Am I missing something obvious because I cannot find a more up to date client? Or do I need to go back a version of the server to keep working ODBC?
View Replies !
ODBC Connection Keeps Dropping Off...
I have a local user on our network running MS Access 2003 (on Win XP Home), which needs to connect to a Back-End MySQL DB on our Cobalt Qube 3 Server. I installed the correct software to run the Access on their Win XP OS, and installed the ODBC MySQL Driver 3.51. When I test the connection in the ODBC panel, CONNECTED ! Then I open MS Access, and great, the app works. If I then close MS Access and re-open, as soon as I hit a button which needs data from MySQL then I get an error stating that this IP cannot connect to the MySQL DB using Password (Yes). I have tried taking the password out of the DSN, and user account for MySQL, but this makes no difference. After the second time trying to open MS Access, it brings up the ODBC Admin panel, and I have to delete the password and try to connect, 'connection failed', then enter the password 'connected!'. If I then open Access it runs, if I then exit & re-start the app 'Cannot connect using IP........., using Password...) I have double checked all the settings in the DSN, and their user account for the MySQL DB. Surely, the PC should be able to connect either all the time, or not at all, not just once, and then lose the connection
View Replies !
MySQL ODBC 3.51 Driver
I have just installed the MySQL ODBC driver 3.51 on an XP machine which is behind a proxy.When I configure my DSN, I can't access the MySQL server which is in the "outside" world.I get this error: [MySQL] [ODBC 3.51 Driver] Unknown MySQL Server Host 'mysqlserver.com' (11004) When I click the [Configure] button in my DSN configuration, I cannot see any field to define a proxy.
View Replies !
ODBC Driver Version 03.51.08
I just installed the last version of the MySQL ODBC driver, version 03.51.08 A bug in the previous version (Default values not returned by the function SQLGetColumns() was corrected and works properly now. However, the following problem still exists: A call to the function SQGetInfo() with SQL_ALTER_TABLE does not return the bitmask SQL_AT_ADD_COLUMN_DEFAULT set, although MySQL does allow default values in ADD COLUMN. The equivalent bitmask for a call with SQL_CREATE_TABLE does return the bit set correctly.
View Replies !
|
TRACKER
