I just got it to work in VB.NET. I played with the connection string. In
fact, I took everything out except the DSN. Here is the code
(VB.net). For the most part it is exactly like VB6 except no SET commands
and no default properties. Try making your connection string minimal in C#.
Dim c As New ADODB.Connection()
Dim r As New ADODB.Recordset()
c.Open("DSN=SchoolStuff")
r = c.Execute("SELECT * FROM classtitles")
While Not r.EOF
MsgBox(r.Fields("classtitle").Value)
r.MoveNext()
End While
r.Close()
r = Nothing
c.Close()
c = Nothing
At 06:01 PM 3/11/2002 -0800, you wrote:
>Hi All,
>
>I'm having problems connecting to MySQL with C# via
>MyODBC 3.51.02; the DSN I created is called 'MySQL1'.
>The error I am receiving is: "The 'MySQL1' provider is
>not registered on the local machine". This is what my
>connection string looks like:
>
>string strConn = "Provider=MySQL1;DNS=MySQL1";
>
>Has anyone faced similar issues? Any advice?
>
>Thanks in advance,
>Jes
>
>__________________________________________________
>Do You Yahoo!?
>Try FREE Yahoo! Mail - the world's greatest free email!
>http://mail.yahoo.com/
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
