Bug #25316 Simple VB/ADO Query Fails with "No database selected"
| Submitted: | 28 Dec 2006 16:43 | Modified: | 10 Jul 2007 5:46 |
|---|---|---|---|
| Reporter: | Jess Balint | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 5.00.10 | OS: | Windows (windows) |
| Assigned to: | Jess Balint | CPU Architecture: | Any |
| Tags: | ODBC5-RC | ||
[12 Jan 2007 13:00]
Renato Gontijo
I had the same problem on MySQL 5.0.27 with MyODBC 3.51.12 on Windows XP. I'm using VB6 and ADO 2.8.
After connect to database with ADO is necessary to send command:
Con.Execute("USE MyDATABASE;")
With other versions of database like 5.0.22 this problem doesn't happen.
I guess that some modification on connection routine made this error. I'm having problems to print reports with Crystal Reports XI with version 5.0.27.
[13 Jan 2007 4:30]
Laurensius Hermawi
This error appeared again when I want to add or update data with this command Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "SELECT * FROM tablename WHERE fieldname= 'XXX' ", Con, adOpenForwardOnly, adLockOptimistic rs!fieldname1="DDD" rs.update ----------
[24 Jan 2007 23:22]
Jess Balint
Problem with DSN-less connect string parsing. Fix committed in rev777.
[18 Jul 2007 4:26]
kudo edokawa
mangwantong/ra I made authen to msql database by use ODBC 5 but i can not authen .because error Fails with "No database selected". what can i do??????
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Trying to issue a simple query from VB/ADO fails with: [MySQL][MyODBC 5.00.11][MySQL] 1046 No database selected How to repeat: Use this VB code (add Microsoft ActiveX Data Objects reference to project): Dim constring As String constring = "DRIVER={MySQL Connector/ODBC v5};server=localhost;uid=myodbctest;pwd=myodbctest;database=test;Option=3" Dim Con As ADODB.Connection Con = New ADODB.Connection Con.ConnectionString = conString Con.Open() Con.Execute("select * from xdata")