Bug #7877 Fatal error ("Katastrofalny błąd" in polish)
Submitted: 13 Jan 2005 15:45 Modified: 13 Feb 2005 20:28
Reporter: Tomasz Rzepecki Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.10 OS:Windows (windows 98,2000,2003,xp)
Assigned to: CPU Architecture:Any

[13 Jan 2005 15:45] Tomasz Rzepecki
Description:
error occur when connecting to mysql via ADO & VB (ASP  not tested). if using ConnectionString property then error="fatal error". if using System DSN then error=" can't connect to mysql server on localhost' ". Host name/adres are prompted properly and connection test (in DSN) are passed. sorry for my english :) 

How to repeat:
in VB 

dim dbconn as new adodb.connection
dbconn.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=servernameoradres;uid=user;pwd=password;database=database"

or

create system DSN

and in vb

dim dbconn as new adodb.connection
dbconn.open "nameOfDSN"
[20 Jan 2005 12:03] Aleksey Kishkin
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Tomasz, you didn't provide mysql settings, grants for this user, and so on. Did you try to "test data source" in ODBC settings?
[13 Feb 2005 20:28] Aleksey Kishkin
it looks like the dup of http://bugs.mysql.com/bug.php?id=7880 but with polish message.