adodc issue

hi,
I am using databinding with the above named control,
but every time i make a change , i get the following
message

"the microsoft jet database engine stopped the
process"


any ideas?

thanks in advance



__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: adodc issue

What's the error code you are getting?

J.R.

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@yahoo.com]
Sent: Thursday, December 09, 2004 12:06 PM
To: mysql list
Subject: adodc issue

hi,
I am using databinding with the above named control, but every time i make a change , i get the
following message

"the microsoft jet database engine stopped the process"


any ideas?

thanks in advance



__________________________________
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=bullijr@innovatim.com



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: adodc issue

--=_alternative 0060527B85256F65_=
Content-Type: text/plain; charset="US-ASCII"

You could stop confusing apples with oranges to start with. I can tell
from your post that you are developing something form-based (but I have no
clue in which language) and are attempting to use a data-bound ADO-based
control. Unfortunately, I am one of those loggerheads who prefer to do
everything by hand (no binding, ever) so I have no experience with that
particular OCX. What I can tell you is that if your control thinks that
your MySQL server is a Jet-type database, you have something seriously
messed up.

What does your connection string look like? (obfuscate your login,
servername, and password, of course). How are you trying to bind that
control to something in the database? Are you going through an ODBC driver
or Connector/Net or trying a direct connection from the control? Please
provide whatever details you can.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Mark Mchugh wrote on 12/09/2004 12:06:14 PM:

> hi,
> I am using databinding with the above named control,
> but every time i make a change , i get the following
> message
>
> "the microsoft jet database engine stopped the
> process"
>
>
> any ideas?
>
> thanks in advance
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Easier than ever with enhanced search. Learn more.
> http://info.mail.yahoo.com/mail_250
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>

--=_alternative 0060527B85256F65_=--

Re: adodc issue

hi,
my connection string is

Set connMySQL = New ADODB.Connection
connMySQL.ConnectionString = "DRIVER={mySQL ODBC
3.51 Driver};" _
& "SERVER=192.168.0.55;" _
& "DATABASE=adjust;" _
& "UID=*****;" _
& "PWD=*****;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384


i'm completely lost!!!!

--- SGreen@unimin.com wrote:

> You could stop confusing apples with oranges to
> start with. I can tell
> from your post that you are developing something
> form-based (but I have no
> clue in which language) and are attempting to use a
> data-bound ADO-based
> control. Unfortunately, I am one of those
> loggerheads who prefer to do
> everything by hand (no binding, ever) so I have no
> experience with that
> particular OCX. What I can tell you is that if your
> control thinks that
> your MySQL server is a Jet-type database, you have
> something seriously
> messed up.
>
> What does your connection string look like?
> (obfuscate your login,
> servername, and password, of course). How are you
> trying to bind that
> control to something in the database? Are you going
> through an ODBC driver
> or Connector/Net or trying a direct connection from
> the control? Please
> provide whatever details you can.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> Mark Mchugh wrote on 12/09/2004
> 12:06:14 PM:
>
> > hi,
> > I am using databinding with the above named
> control,
> > but every time i make a change , i get the
> following
> > message
> >
> > "the microsoft jet database engine stopped the
> > process"
> >
> >
> > any ideas?
> >
> > thanks in advance
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail - Easier than ever with enhanced
> search. Learn more.
> > http://info.mail.yahoo.com/mail_250
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=sgreen@unimin.com
> >
>




__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: adodc issue

I used ADODB objects with VBA to connect to MySQL and it worked, did
you include the right references for your project? You may try
installing the most recent MDAC for Windows. You may have a problem
with ADO, by the time I worked with this I was using 2.7 recordset
library.

Thats it, hope that helps,

(by the way, someone really hates me on this list, I got a unsubscribe
request from 217.91.105.119) :P *LOL*

On Fri, 10 Dec 2004 03:41:39 -0800 (PST), Mark Mchugh
wrote:
> hi,
> my connection string is
>
> Set connMySQL = New ADODB.Connection
> connMySQL.ConnectionString = "DRIVER={mySQL ODBC
> 3.51 Driver};" _
> & "SERVER=192.168.0.55;" _
> & "DATABASE=adjust;" _
> & "UID=*****;" _
> & "PWD=*****;" _
> & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
>
> i'm completely lost!!!!
>
>
>
> --- SGreen@unimin.com wrote:
>
> > You could stop confusing apples with oranges to
> > start with. I can tell
> > from your post that you are developing something
> > form-based (but I have no
> > clue in which language) and are attempting to use a
> > data-bound ADO-based
> > control. Unfortunately, I am one of those
> > loggerheads who prefer to do
> > everything by hand (no binding, ever) so I have no
> > experience with that
> > particular OCX. What I can tell you is that if your
> > control thinks that
> > your MySQL server is a Jet-type database, you have
> > something seriously
> > messed up.
> >
> > What does your connection string look like?
> > (obfuscate your login,
> > servername, and password, of course). How are you
> > trying to bind that
> > control to something in the database? Are you going
> > through an ODBC driver
> > or Connector/Net or trying a direct connection from
> > the control? Please
> > provide whatever details you can.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
> > Mark Mchugh wrote on 12/09/2004
> > 12:06:14 PM:
> >
> > > hi,
> > > I am using databinding with the above named
> > control,
> > > but every time i make a change , i get the
> > following
> > > message
> > >
> > > "the microsoft jet database engine stopped the
> > > process"
> > >
> > >
> > > any ideas?
> > >
> > > thanks in advance
> > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Mail - Easier than ever with enhanced
> > search. Learn more.
> > > http://info.mail.yahoo.com/mail_250
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=sgreen@unimin.com
> > >
> >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: adodc issue

--=_alternative 004EC9F385256F66_=
Content-Type: text/plain; charset="US-ASCII"

OK, I can tell by your code that you are using a Basic variant (Visual
Basic or VBA) but I don't see a reference to your control (are you using a
control? Which one?) I see nothing wrong with what you posted so far.
Also your example shows you using an ADODB.Connection not an ADODC
control. Which is it? Are you using a data bound control or are you using
the ADODB objects directly?

Please answer my other questions (from my first response), too, as I am
still under-informed of what you are attempting to do. I have loads of
experience using the ADODB library directly, I just need more details
about what you are wanting to do, how you are doing it, and what you hope
to achieve.

Thanks!

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


Daniel da Veiga wrote on 12/10/2004 08:34:16 AM:

> I used ADODB objects with VBA to connect to MySQL and it worked, did
> you include the right references for your project? You may try
> installing the most recent MDAC for Windows. You may have a problem
> with ADO, by the time I worked with this I was using 2.7 recordset
> library.
>
> Thats it, hope that helps,
>
> (by the way, someone really hates me on this list, I got a unsubscribe
> request from 217.91.105.119) :P *LOL*
>
> On Fri, 10 Dec 2004 03:41:39 -0800 (PST), Mark Mchugh
> wrote:
> > hi,
> > my connection string is
> >
> > Set connMySQL = New ADODB.Connection
> > connMySQL.ConnectionString = "DRIVER={mySQL ODBC
> > 3.51 Driver};" _
> > & "SERVER=192.168.0.55;" _
> > & "DATABASE=adjust;" _
> > & "UID=*****;" _
> > & "PWD=*****;" _
> > & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
> >
> > i'm completely lost!!!!
> >
> >
> >
> > --- SGreen@unimin.com wrote:
> >
> > > You could stop confusing apples with oranges to
> > > start with. I can tell
> > > from your post that you are developing something
> > > form-based (but I have no
> > > clue in which language) and are attempting to use a
> > > data-bound ADO-based
> > > control. Unfortunately, I am one of those
> > > loggerheads who prefer to do
> > > everything by hand (no binding, ever) so I have no
> > > experience with that
> > > particular OCX. What I can tell you is that if your
> > > control thinks that
> > > your MySQL server is a Jet-type database, you have
> > > something seriously
> > > messed up.
> > >
> > > What does your connection string look like?
> > > (obfuscate your login,
> > > servername, and password, of course). How are you
> > > trying to bind that
> > > control to something in the database? Are you going
> > > through an ODBC driver
> > > or Connector/Net or trying a direct connection from
> > > the control? Please
> > > provide whatever details you can.
> > >
> > > Shawn Green
> > > Database Administrator
> > > Unimin Corporation - Spruce Pine
> > >
> > > Mark Mchugh wrote on 12/09/2004
> > > 12:06:14 PM:
> > >
> > > > hi,
> > > > I am using databinding with the above named
> > > control,
> > > > but every time i make a change , i get the
> > > following
> > > > message
> > > >
> > > > "the microsoft jet database engine stopped the
> > > > process"
> > > >
> > > >
> > > > any ideas?
> > > >
> > > > thanks in advance
> > > >
> > > >
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Yahoo! Mail - Easier than ever with enhanced
> > > search. Learn more.
> > > > http://info.mail.yahoo.com/mail_250
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives: http://lists.mysql.com/win32
> > > > To unsubscribe:
> > > http://lists.mysql.com/win32?unsub=sgreen@unimin.com
> > > >
> > >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail - Helps protect you from nasty viruses.
> > http://promotions.yahoo.com/new_mail
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe: http://lists.mysql.com/win32?
> unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>

--=_alternative 004EC9F385256F66_=--

RE: ADODB issue

Some other things to look at...

1) Unless you are using .NET technology, you should be using either a DIM statement or a
Server.CreateObject(ADODB.Connection) statement, not "New ADODB.Connection"

2) Might have just been the email formatting, but also check your code that you do not have a
carriage return inside your connection string.

Yours (as in the email):
connMySQL.ConnectionString = "DRIVER={mySQL ODBC
3.51 Driver};" _

Should be:
connMySQL.ConnectionString = "DRIVER={mySQL ODBC 3.51 Driver};" _

3) Also, make sure that you remove the trailing spaces between " and _ on your strings.

Yours (as in the email): ;" _
Should be: ;"_

4) Mundane but could make all the difference - check your MySQL database name. If the database is
being hosted on Linux, it is Case Sensitive. Table names aren't in your ASP/ASP.NET code, but in the
connection string I have found that it does.

5) Of course, follow what Shawn and Daniel said and make sure your current versions of the ADO Jet
Engine (4.0 SP8), ODBC driver (3.51.09) and MDAC (2.8) are the latest and greatest.

6) Just an observation, but you can add all your options together and use an integer.

Instead of: & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
Try: & "OPTION=18475"

J.R.


-----Original Message-----
From: SGreen@unimin.com [mailto:SGreen@unimin.com]
Sent: Friday, December 10, 2004 9:18 AM
To: Mark Mchugh
Cc: win32@lists.mysql.com
Subject: Re: adodc issue

OK, I can tell by your code that you are using a Basic variant (Visual Basic or VBA) but I don't see
a reference to your control (are you using a control? Which one?) I see nothing wrong with what you
posted so far.
Also your example shows you using an ADODB.Connection not an ADODC control. Which is it? Are you
using a data bound control or are you using the ADODB objects directly?

Please answer my other questions (from my first response), too, as I am still under-informed of
what you are attempting to do. I have loads of experience using the ADODB library directly, I just
need more details about what you are wanting to do, how you are doing it, and what you hope to
achieve.

Thanks!

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


Daniel da Veiga wrote on 12/10/2004 08:34:16 AM:

> I used ADODB objects with VBA to connect to MySQL and it worked, did
> you include the right references for your project? You may try
> installing the most recent MDAC for Windows. You may have a problem
> with ADO, by the time I worked with this I was using 2.7 recordset
> library.
>
> Thats it, hope that helps,
>
> (by the way, someone really hates me on this list, I got a unsubscribe
> request from 217.91.105.119) :P *LOL*
>
> On Fri, 10 Dec 2004 03:41:39 -0800 (PST), Mark Mchugh
> wrote:
> > hi,
> > my connection string is
> >
> > Set connMySQL = New ADODB.Connection
> > connMySQL.ConnectionString = "DRIVER={mySQL ODBC
> > 3.51 Driver};" _
> > & "SERVER=192.168.0.55;" _
> > & "DATABASE=adjust;" _
> > & "UID=*****;" _
> > & "PWD=*****;" _
> > & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
> >
> > i'm completely lost!!!!
> >
> >
> >
> > --- SGreen@unimin.com wrote:
> >
> > > You could stop confusing apples with oranges to start with. I can
> > > tell from your post that you are developing something form-based
> > > (but I have no clue in which language) and are attempting to use a
> > > data-bound ADO-based control. Unfortunately, I am one of those
> > > loggerheads who prefer to do everything by hand (no binding, ever)
> > > so I have no experience with that particular OCX. What I can tell
> > > you is that if your control thinks that your MySQL server is a
> > > Jet-type database, you have something seriously messed up.
> > >
> > > What does your connection string look like?
> > > (obfuscate your login,
> > > servername, and password, of course). How are you trying to bind
> > > that control to something in the database? Are you going through
> > > an ODBC driver or Connector/Net or trying a direct connection from
> > > the control? Please provide whatever details you can.
> > >
> > > Shawn Green
> > > Database Administrator
> > > Unimin Corporation - Spruce Pine
> > >
> > > Mark Mchugh wrote on 12/09/2004
> > > 12:06:14 PM:
> > >
> > > > hi,
> > > > I am using databinding with the above named
> > > control,
> > > > but every time i make a change , i get the
> > > following
> > > > message
> > > >
> > > > "the microsoft jet database engine stopped the process"
> > > >
> > > >
> > > > any ideas?
> > > >
> > > > thanks in advance
> > > >
> > > >
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > Yahoo! Mail - Easier than ever with enhanced
> > > search. Learn more.
> > > > http://info.mail.yahoo.com/mail_250
> > > >
> > > > --
> > > > MySQL Windows Mailing List
> > > > For list archives: http://lists.mysql.com/win32
> > > > To unsubscribe:
> > > http://lists.mysql.com/win32?unsub=sgreen@unimin.com
> > > >
> > >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail - Helps protect you from nasty viruses.
> > http://promotions.yahoo.com/new_mail
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe: http://lists.mysql.com/win32?
> unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: ADODB issue

--------------ms030808020405060005040003
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> 6) Just an observation, but you can add all your options together and
use an integer.
>
> Instead of: & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
> Try: & "OPTION=18475"
>

Actually there is a reason for the former usage. I pretty much came up
with the first version you see above, and I did it because I was
constantly being asked about what 18475 meant in my articles at
www.vbmysql.com. By breaking it up one can easily see what the component
integers are and also easily add or remove a flag. So I think it is best
to use the above usage for readability's sake.

--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870

"The Open Source movement has become a major force across the software
industry, and MySQL is the world's most popular open source database."
--Fortune Magazine



--------------ms030808020405060005040003
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIII7TCC
AtEwggI6oAMCAQICAw0sKjANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJa QTElMCMGA1UE
ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDQxMDA1MTc0MjE5WhcNMDUx MDA1MTc0MjE5
WjBEMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSEwHwYJKoZI hvcNAQkBFhJt
aGlsbHllckBteXNxbC5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEK AoIBAQDtVeH/
VjggNLRFI6lJWcNKzegH4wLy5XY9maNWV3bj+KOfAF4O9AwtsGvrWzXQ3Q0z heVEbEMFViQ4
F8tFbWfzIzE9+v5A+loZAr83mJ+CRQXgR752wS+36VU9qwULhThlhB9WO+bI kuTYTEWgaYsK
4D53IGOWO2z4bNjMTKMM6DnqREfgnx7aiISFFHe4KRljsshtSWgf5p/FbOqY f9V/OObL9/W4
kwqasn9QqQ5tz70VCvs2c8Tq9iUgb6u/baExBV6iBzZfOv5n8Wp3DysE9UF6 UZJCsgDOHSoK
RJThQYRCn1IQ/KH16MnAR/NtPyoMz+vk6GG2WqZrWZEtKrrnAgMBAAGjLzAt MB0GA1UdEQQW
MBSBEm1oaWxseWVyQG15c3FsLmNvbTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3 DQEBBAUAA4GB
AKN/l7DwzIuuXP0lKrXCdMTG+Qx08LsYMrlcQ+XYj/3fUMeiOzWvM0J8lWM6 qc3Dlo0mLFIC
DUJkJ16T20CWtXbwW0xnxNeh1WSqVN5sxdUQy+7Op7jum+fCxv05bedXF+sX 8ft2rdCIdmG9
grfqtIWFbMZqZK5iczMktq8fc6uEMIIC0TCCAjqgAwIBAgIDDSwqMA0GCSqG SIb3DQEBBAUA
MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAo UHR5KSBMdGQu
MSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBD QTAeFw0wNDEw
MDUxNzQyMTlaFw0wNTEwMDUxNzQyMTlaMEQxHzAdBgNVBAMTFlRoYXd0ZSBG cmVlbWFpbCBN
ZW1iZXIxITAfBgkqhkiG9w0BCQEWEm1oaWxseWVyQG15c3FsLmNvbTCCASIw DQYJKoZIhvcN
AQEBBQADggEPADCCAQoCggEBAO1V4f9WOCA0tEUjqUlZw0rN6AfjAvLldj2Z o1ZXduP4o58A
Xg70DC2wa+tbNdDdDTOF5URsQwVWJDgXy0VtZ/MjMT36/kD6WhkCvzeYn4JF BeBHvnbBL7fp
VT2rBQuFOGWEH1Y75siS5NhMRaBpiwrgPncgY5Y7bPhs2MxMowzoOepER+Cf HtqIhIUUd7gp
GWOyyG1JaB/mn8Vs6ph/1X845sv39biTCpqyf1CpDm3PvRUK+zZzxOr2JSBv q79toTEFXqIH
Nl86/mfxancPKwT1QXpRkkKyAM4dKgpElOFBhEKfUhD8ofXoycBH820/KgzP 6+ToYbZapmtZ
kS0quucCAwEAAaMvMC0wHQYDVR0RBBYwFIESbWhpbGx5ZXJAbXlzcWwuY29t MAwGA1UdEwEB
/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAo3+XsPDMi65c/SUqtcJ0xMb5DHTw uxgyuVxD5diP
/d9Qx6I7Na8zQnyVYzqpzcOWjSYsUgINQmQnXpPbQJa1dvBbTGfE16HVZKpU 3mzF1RDL7s6n
uO6b58LG/Tlt51cX6xfx+3at0Ih2Yb2Ct+q0hYVsxmpkrmJzMyS2rx9zq4Qw ggM/MIICqKAD
AgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UE CBMMV2VzdGVy
biBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBD b25zdWx0aW5n
MSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQw IgYDVQQDExtU
aGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBl cnNvbmFsLWZy
ZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1 OTU5WjBiMQsw
CQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg THRkLjEsMCoG
A1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8w DQYJKoZIhvcN
AQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb 8hp2vX8MOmHy
v1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xz gnc9A74r/rsY
Pge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQw gZEwEgYDVR0T
AQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRo YXd0ZS5jb20v
VGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYD VR0RBCIwIKQe
MBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUA A4GBAEiM0VCD
6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFh YsPZOhl+hLGZ
GwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAa WzVNd+NWIXiC
3CEZNd4ksdMdRv9dX2VPMYIDOzCCAzcCAQEwaTBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMc
VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3Rl IFBlcnNvbmFs
IEZyZWVtYWlsIElzc3VpbmcgQ0ECAw0sKjAJBgUrDgMCGgUAoIIBpzAYBgkq hkiG9w0BCQMx
CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNDEyMTAxNTMxMjNaMCMG CSqGSIb3DQEJ
BDEWBBRG9nX2KSD/J3mQlVbUXzazXh6MyTBSBgkqhkiG9w0BCQ8xRTBDMAoG CCqGSIb3DQMH
MA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggq hkiG9w0DAgIB
KDB4BgkrBgEEAYI3EAQxazBpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29u
c3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwg RnJlZW1haWwg
SXNzdWluZyBDQQIDDSwqMHoGCyqGSIb3DQEJEAILMWugaTBiMQswCQYDVQQG EwJaQTElMCMG
A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj VGhhd3RlIFBl
cnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw0sKjANBgkqhkiG9w0BAQEF AASCAQB4YhjW
0JKhjmT9soLIVUWb6bm424WchhRsobrz+MQdRbg493fpClOOb47c3/H1lWiz FjzonpJIZkMQ
w3CeCbfjrLwwQIaYFXD33o4dndgGYXWEri141tKSY3SOXEmr4Rj3OUaqQfq6 Czkwfh8Az7vh
Um38AF8Efe6N32aAs3E2OzpUDEoOASeSyp57amPWIUcdVCI5p2TrfF54XUc5 0tRT1suQrD9H
A6sdb9y6+1LPdMU6Xo203UaXh0bviyrw+sd9eYPluBtueIZyPijO1Sqhhtgg ewf5jy/UOMfU
BdD7R/gn3OqkpYsnXkk7GmVnHGX7X/XGMMyx9RmhZHT5NrHtAAAAAAAA
--------------ms030808020405060005040003--

RE: ADODB issue

------=_NextPart_000_0192_01C4DEA4.11B342A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Then I stand corrected. Please accept my apologies.

J.R.

-----Original Message-----
From: Mike Hillyer [mailto:mhillyer@mysql.com]
Sent: Friday, December 10, 2004 10:31 AM
To: J.R. Bullington
Cc: win32@lists.mysql.com
Subject: Re: ADODB issue

> 6) Just an observation, but you can add all your options together and use an integer.
>
> Instead of: & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384 > Try: & "OPTION=18475"
>

Actually there is a reason for the former usage. I pretty much came up with the first version you
see above, and I did it because I was constantly being asked about what 18475 meant in my articles
at www.vbmysql.com. By breaking it up one can easily see what the component integers are and also
easily add or remove a flag. So I think it is best to use the above usage for readability's sake.

--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870

"The Open Source movement has become a major force across the software industry, and MySQL is the
world's most popular open source database."
--Fortune Magazine



------=_NextPart_000_0192_01C4DEA4.11B342A0
Content-Type: application/x-pkcs7-signature;
name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIIyzCCAlMw
ggG8oAMCAQICAwz29jANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDQwOTAxMTgyMzQzWhcNMDUwOTAxMTgyMzQz WjBHMR8wHQYDVQQD
ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSQwIgYJKoZIhvcNAQkBFhVidWxs aWpyQGlubm92YXRp
bS5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAKO9OYAUZ4fOUsqo eUMZ4gbd/578vayp
DXoysPR9zWcN/NqNu75RpfuOEidVIlsjMIhOKmwy0IwImDCibgcSfGfUfuMO ScyKMVW0/nz8Zn01
BfZPmbQvngtDt7Q3A17NbFPLT8KFBNms8jawvTUxrjkkq7S/GdLHfNQjPIZB iCTPAgMBAAGjMjAw
MCAGA1UdEQQZMBeBFWJ1bGxpanJAaW5ub3ZhdGltLmNvbTAMBgNVHRMBAf8E AjAAMA0GCSqGSIb3
DQEBBAUAA4GBALSAomg4+7oinqhmtfKFbV3Sa0a9fxQxbhgnXmmOQ2SNceXt 6KZ2iFUT4zkcFxFF
ZbWnzcwcfOmQjs9o0OC0y0lbF8n89dx74tD+HVtb1NgNaJ222eHVhcVbHAUv Re6VScevq1c5Gt/z
GbQluP58KiJsei/Hz9CY01Ue7Rj6WmkcMIIDLTCCApagAwIBAgIBADANBgkq hkiG9w0BAQQFADCB
0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UE BxMJQ2FwZSBUb3du
MRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2VydGlm aWNhdGlvbiBTZXJ2
aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIENBMSswKQYJ
KoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4XDTk2 MDEwMTAwMDAwMFoX
DTIwMTIzMTIzNTk1OVowgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0 ZXJuIENhcGUxEjAQ
BgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcx KDAmBgNVBAsTH0Nl
cnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0 ZSBQZXJzb25hbCBG
cmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxA dGhhd3RlLmNvbTCB
nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA1GnX1LCUZFtx6UfYDFG26nKR sIRefS0Nj3sS34Ul
dSh0OkIsYyeflXtL734Zhx2G6qPduc6WZBrCFG5ErHzmj+hND3EfQDimAKOH ePb5lIZererAXnbr
2RSjXW56fAylS1V/Bhkpf56aJtVquzgkCGqYx7Hao5iR/Xnb5VrEHLkCAwEA AaMTMBEwDwYDVR0T
AQH/BAUwAwEB/zANBgkqhkiG9w0BAQQFAAOBgQDH7JJ+Tvj1lqVnYiqk8E0R YNBvjWBYYawmu1I1
XAjPMPuoSpaKH2JCI4wXD/S6ZJwXrEcp352YXtJsYHFcoqzceePnbgBHH7UN KOgCneSa/RP0ptl8
sfjcXyMmCZGAc9AUG95DqYMl8uacLxXK/qarigd1iwzdUYRr5PjRzneigTCC Az8wggKooAMCAQIC
AQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUx
EjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp bmcxKDAmBgNVBAsT
H0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro YXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h aWxAdGhhd3RlLmNv
bTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYT AlpBMSUwIwYDVQQK
ExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3 dGUgUGVyc29uYWwg
RnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkC gYEAxKY8VXNV+065
yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkV cI7dyfArhVqqP3FW
y688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUP SAR/p7bRPGEEQB5k
GXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8 MDowOKA2oDSGMmh0
dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0Eu Y3JsMAsGA1UdDwQE
AwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0x MzgwDQYJKoZIhvcN
AQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2f Ni/A9BxQIJNwPP2t
4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH 1sYITq726jTlEBpb
NU1341YheILcIRk13iSx0x1G/11fZU8xggLPMIICywIBATBpMGIxCzAJBgNV BAYTAlpBMSUwIwYD
VQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU aGF3dGUgUGVyc29u
YWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDPb2MAkGBSsOAwIaBQCgggG8MBgG CSqGSIb3DQEJAzEL
BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA0MTIxMDE1MzYxMlowIwYJ KoZIhvcNAQkEMRYE
FFbgbO0BRC1CwigPB9pT/Yxl0lTfMGcGCSqGSIb3DQEJDzFaMFgwCgYIKoZI hvcNAwcwDgYIKoZI
hvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMC AgEoMAcGBSsOAwIa
MAoGCCqGSIb3DQIFMHgGCSsGAQQBgjcQBDFrMGkwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRo
YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVl
bWFpbCBJc3N1aW5nIENBAgMM9vYwegYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJ BgNVBAYTAlpBMSUw
IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD EyNUaGF3dGUgUGVy
c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDPb2MA0GCSqGSIb3DQEBAQUA BIGAnZHr9NdSE2Gd
4I/ZDvQfXrP3EhNDex0mZcWJlzekr9I5dp8p3hktlJWSCrTHgyRxRSNW9Et+ /a9TeOPTOzJ7qA0N
GVqETN9bBXJMYAjBRdSplGpelO9a2ytXGtZrHPxiai0qGiAwXpiDnYdMqoyz ptI1J6GFkaJZ5Zz5
yhfVV1EAAAAAAAA=

------=_NextPart_000_0192_01C4DEA4.11B342A0--

Re: adodc issue

You don't say if you tried to find who this was, but I just tried a Linux
'whois 217.91.105.119@whois.ripe.net', and if it isn't just a spoof, the
address belongs to a Deutsche Telekom subscriber. Their abuse address is
www.t-com.de/ip-abuse.

Rgds, GStC.


----- Original Message -----
From: "Daniel da Veiga"
To: "MySQL Win32 List"
Sent: Friday, December 10, 2004 8:34 AM
Subject: Re: adodc issue


> I used ADODB objects with VBA to connect to MySQL and it worked, did
> you include the right references for your project? You may try
> installing the most recent MDAC for Windows. You may have a problem
> with ADO, by the time I worked with this I was using 2.7 recordset
> library.
>
> Thats it, hope that helps,
>
> (by the way, someone really hates me on this list, I got a unsubscribe
> request from 217.91.105.119) :P *LOL*



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: adodc issue

Your unsubscribe link is a the bottom of each message from this list. When =
replying, be sure to delete the link before sending.

Randy Clamons
Systems Programming
Astro-auction.com


> ------------Original Message------------
> From: "Graeme St.Clair"
> To: "Daniel da Veiga" , "MySQL Win32 List" 2@lists.mysql.com>
> Date: Fri, Dec-10-2004 5:40 PM
> Subject: Re: adodc issue
>
> You don't say if you tried to find who this was, but I just tried a =

> Linux
> 'whois 217.91.105.119@whois.ripe.net', and if it isn't just a spoof, =

> the
> address belongs to a Deutsche Telekom subscriber. Their abuse address =

> is
> www.t-com.de/ip-abuse.
> =

> Rgds, GStC.
> =

> =

> ----- Original Message ----- =

> From: "Daniel da Veiga"
> To: "MySQL Win32 List"
> Sent: Friday, December 10, 2004 8:34 AM
> Subject: Re: adodc issue
> =

> =

> > I used ADODB objects with VBA to connect to MySQL and it worked, did
> > you include the right references for your project? You may try
> > installing the most recent MDAC for Windows. You may have a problem
> > with ADO, by the time I worked with this I was using 2.7 recordset
> > library.
> >
> > Thats it, hope that helps,
> >
> > (by the way, someone really hates me on this list, I got a =

> unsubscribe
> > request from 217.91.105.119) :P *LOL*
> =



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org