Used the latest ODBC-Driver supplied from www.mysql.com
->libmyodbc3.so
odbc.ini:
[wintime_sql]
Driver = MySQL ODBC 3.51 Driver
DATABASE = wtimtestschmuck
PWD = ####
SERVER = localhost
UID = #####
odbcinst.ini
[MySQL ODBC 3.51 Driver]
DRIVER = /usr/lib/libmyodbc3.so
SETUP = /usr/lib/libmyodbc3S.so
UsageCount = 1
here is the code snipped
If GlOdbcDsn <> "" Then
VarConnStr = "DSN=" & GlOdbcDsn & ";" & _
"UID=" & GlDbUserName & ";PWD=" & GlDbPassword & ";"
900: Else
VarConnStr = "DRIVER={" & GlOdbcDriver & "};" & _
"SERVER=" & GlDbHost & ";" & _
"PORT=" & GlDbPort & ";" & _
"DATABASE=" & GlDbName & ";" & _
"UID=" & GlDbUserName & ";PWD=" & GlDbPassword & ";"
End If
910: For VarConnZ = 1 To ModConnMySqlOdbc.GetUpperBound(0)
920: If ModConnMySqlOdbc(VarConnZ) Is Nothing Then Exit For
930: Next
940: If VarConnZ > ModConnMySqlOdbc.GetUpperBound(0) Then
950: ReDim Preserve ModConnMySqlOdbc(VarConnZ)
960: ReDim Preserve ModCommMySqlOdbc(VarConnZ)
970: ReDim Preserve ModDRMySqlOdbc(VarConnZ)
980: ModConnMySqlOdbc(VarConnZ) = Nothing
990: ModCommMySqlOdbc(VarConnZ) = Nothing
1000: ModDRMySqlOdbc(VarConnZ) = Nothing
End If
1010: ModConnMySqlOdbc(VarConnZ) = New Odbc.OdbcConnection(VarConnStr)
1020: ModCommMySqlOdbc(VarConnZ) = New Odbc.OdbcCommand
Try
1040: ModConnMySqlOdbc(VarConnZ).Open()
Try
1050: ModCommMySqlOdbc(VarConnZ).Connection =
ModConnMySqlOdbc(VarConnZ)
....
Usually our code exits by .Open()
hope this helps.
Regards,
Schmuck
-----Ursprüngliche Nachricht-----
Von: T Senganal [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 7. Juni 2006 11:37
An: Schmuck; [email protected]
Betreff: Re: [Mono-list] MySql - ODBC
Hi
> have an issue using MySQL with ODBC.
> I have a System and User DSN, that I testet with "isql" succesfully.
> The problems begin with running our .Net --> see stacktrace
Odbc Provider usually works fine with mysql.. Can u pls post the code
that causes the issue.. Also mention info on the Odbc Driver name and
version..
Regards
Senga
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
