Bug #12372 ERROR [01000] [
Submitted: 4 Aug 2005 11:20 Modified: 12 Apr 2007 19:16
Reporter: StuFF mc Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.0.0 OS:Any (Server Fedora - Client XP sp 2)
Assigned to: Jess Balint CPU Architecture:Any

[4 Aug 2005 11:20] StuFF mc 
Description:
"ERROR [01000] [" when using connection string which works with MyODBC 3.51 (re-tested just after the 5.0.0 bug).

How to repeat:
Factory = DbProviderFactories.GetFactory("System.Data.Odbc")
Connection = Factory.CreateConnection()
Connection.ConnectionString = "DSN=MyDSN;USER=MyUser;PASSWORD=MyPwd;OPTION=3;"
Connection.Open()

Gives:

---------------------------
MsgBox
---------------------------
ERROR [01000] [
---------------------------
            OK()
---------------------------
[5 Aug 2005 9:00] Vasily Kishkin 
Could you please write full text of your test case and attach to "Files"?
[5 Aug 2005 9:05] StuFF mc 
What do you mean by "full text" ?? Just a simple ODBC connection with the CreateConnection of .NET 2....
[14 Aug 2005 8:49] Vasily Kishkin 
Could you please say me what version of MVS you use ?
[14 Aug 2005 12:24] StuFF mc 
MVS ??
[19 Aug 2005 4:06] rob Baldwin 
OS = Windows 2000 sp4
Using Microsoft Visual Studio 6.0

/****************/
/*** Test Code ***/

RETCODE rc;
SQLHENV henv;
SQLHDBC hdbc;
HSTMT hstmt;

rc = SQLAllocEnv(&henv);
rc = SQLAllocConnect(henv,&hdbc);
rc = SQLConnect(hdbc,"testdsn",SQL_NTS,"test",SQL_NTS,"test",SQL_NTS);

return code =-1 after the above call producing the same ERROR[01000]

when setting up the dsn under control panel the connection was successful.
[19 Aug 2005 8:39] Vasily Kishkin 
I was able to reproduce the bug. I attached my test case to "Files". Thanks for bug report.
[19 Aug 2005 8:40] Vasily Kishkin 
Test case

Attachment: test.c (text/plain), 3.14 KiB.
[12 Apr 2007 19:16] Jess Balint 
Fixed along the way, test case reports:

Connect....

ERROR (bug12372.c:46): SQLDriverConnect()
*** [MySQL][MyODBC 5.00.12][MySQL] 1045 Access denied for user 'ODBC'@'localhost' (using password: NO)
*** ODBC Code: 08001, Driver Code: 1045