Thanks,
Barry G. Sumpter
Proud Tritoneer
President - Triton Woodworkers Club Holmesglen
THE TRITONEER
Woodworking Australia Bulletin Board
Triton Owners and Users Forum
Holmesglen Short/DIY Courses
Triton Weekend Workshop
Triton Woodworking Systems I
Triton Woodworking Systems II
[EMAIL PROTECTED]
(613) 9889-6727
0407 856 646
-Original Message-
From: Barry G. Sumpter [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 26 January 2003 2:33 PM
To: '[EMAIL PROTECTED]'
Subject: Needed: Working VB6 example of DAO DSN LESS connection using
MyODBC to MySQL preferably with passthruquery
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
