This message intended for MyODBC questions list.
Hello VB6, MySQL, and DAO developers,
A very simple example of my problem:
Dim ws As Workspace
Dim conn As Connection
Dim str As String
Set ws = DBEngine.CreateWorkspace("testing", "", "", dbUseODBC)
str = "odbc;driver={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& " DATABASE=test;" _
& "UID=;PWD=;OPTION=3"
Set conn = ws.OpenConnection("test", dbDriverNoPrompt, False , str)
'this last line errors with
' -- Run-time error '3146' - ODBC--Call Failed.
'if I use:
' Set conn = ws.OpenConnection("test", dbDriverPrompt, False , str)
'and just select OK on the ODBC Connection Manager
' everything work properly - I can't figure out why.
' Maybe because this turns my connection into a DSN
connection.
I'm using all the latest and gratest installs on a MS WIndows 2000.
Does anyone know OFFICIALLY if the DAO DSN LESS openconnection is
supposed to work or not?
If so, could you please post hyperlink for all to share?
Can anyone please test this OpenConnection on their PC?
Can you get it to work?
If so, Could you please post the working code here for all to share?
Does anyone have DAO DSN LESS openconnection code working?
If so, Could you please post your working code here for all to share?
I'm interested in working/tested/proven code examples.
Also, could someone please point me in the right direction for setting
the passthruquery flag?
Where do I set the flag? MySQL or maybe in the connection settings?
If you don't know what DSN LESS means then please post your question in
another thread.
If you want to discuss ADO over DAO please post your question in another
thread.
Thanks,
Barry G. Sumpter
---------------------------------------------------------------------
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
