 | | | ADODB issue | ADODB issue 2004-12-10 - By J.R. Bullington
Back
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@(protected) [mailto:SGreen@(protected)]
Sent: Friday, December 10, 2004 9:18 AM
To: Mark Mchugh
Cc: win32@(protected)
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 <danieldaveiga@(protected)> 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
> <mark_mch@(protected)> 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@(protected) 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 <mark_mch@(protected)> 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@(protected)
> > > >
> > >
> >
> > __ ____ ____ ____ ____ ____ ______
> > 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@(protected)
> >
> >
>
>
> --
> 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@(protected)
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|