Hi there
I am using the same setup as yourself, but developing with MYVBQL.dll which
is a DLL that some kind fella put together for dummies like me. Works well
and very similar to ADO, couple bugs that I have picked up, but there are
workarounds.
Check the MYSQL web site for the download.
Regards
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Nipanjan Gupta Rajan
> Sent: 24 June 2001 10:37
> To: [EMAIL PROTECTED]
> Subject: MyODBC through ADO
>
>
> I am working to develope a software package using MS Visual
> Basic and MySQL, and so I want know about connnecting MyODBC
> through ADO (ActiveX Data Object) of VB. The format for ODBC
> connectivity through ADO is like :::::: ==>
> ' ' Open a connection without using a Data Source Name (DSN).
> ' Set cnn1 = New ADODB.Connection
> ' cnn1.ConnectionString = "driver={SQL
> Server};server=bigsmile;uid=sa;pwd=pwd;database=pubs"
> ' cnn1.ConnectionTimeout = 30
> ' cnn1.Open
> ' ' Open a connection using a DSN and ODBC tags.
> ' Set cnn2 = New ADODB.Connection
> ' cnn2.ConnectionString = "DSN=Pubs;UID=sa;PWD=pwd;"
> ' cnn2.Open
> ' ' Open a connection using a DSN and OLE DB tags.
> ' Set cnn3 = New ADODB.Connection
> ' cnn3.ConnectionString = "Data Source=Pubs;User
> ID=sa;Password=pwd;"
> ' cnn3.Open
> ' ' Open a connection using a DSN and individual
> ' ' arguments instead of a connection string.
> ' Set cnn4 = New ADODB.Connection
> ' cnn4.Open "Pubs", "sa", "pwd"
> ' Display the state of the connections.
> ' MsgBox "cnn1 state: " & GetState(cnn1.State) & vbCr & _
> ' "cnn2 state: " & GetState(cnn2.State) & vbCr & _
> ' "cnn3 state: " & GetState(cnn3.State) & vbCr & _
> ' "cnn4 state: " & GetState(cnn4.State) ' Open a
> connection using a DSN and ODBC tags.
> ' cnn4.Close
> ' cnn3.Close
> ' cnn2.Close
> ' cnn1.Close
> ' End Sub
>
> (Source MSDN).
> First I'l install the MySQL in a remote NT server and also
> MyODBC in Client machine. Then I'll create a File DSN using
> MyODBC. Now what Provider name (eg For Oracle "MSDAORA") and
> ConnectString should I give ?
>
---------------------------------------------------------------------
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
