Re: OLEDB Provider for Mysql
MyODBC/MySQL connections can be made DSN less. >> Original Message << On 3/4/04, 11:28:19 AM, Gilbert Wu <[EMAIL PROTECTED]> wrote regarding OLEDB Provider for Mysql: > Hi, > We are developing in Microsoft's C++.NET with MS SQL Server as the underlying DBMS. We are planning to move to MySQL.Please kindly advise if there is a OLEDB provider for MySQL? or do I have to stay with ODBC? > Many thanks. > Gilbert Wu > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: OleDB
Hi, I think that adding .;Extended Properties="OPTION=16400" to your ADO connection string should do the trick. Cheers, Bruce -Original Message- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 13:29 To: [EMAIL PROTECTED] Subject: OleDB Hello Im using OleDB from my ASP pages and I have a problem with queries with count(*) and group by statement. I had the same problem with ODBC but i Solved it by setting the "Change BigInt to Int" and the "Return all rows" option. Now I changed to OleDB for better speed but I don't know how to set these options. So far my Database is pretty small with just 20 tables but it will grow fast and i want to use the best connection from start. Anybody have any ideas? Regards Mattias Persson - 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 - 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
Re: OleDB
Thanks, now I got that working... When I used MyODBC I had to use "option=16386;" in the connectionstring to set the change bigint to int option when i use count(*) and Group By queryes. How do I set this in MyOLEDb??? - Original Message - From: "Fredrick Bartlett" <[EMAIL PROTECTED]> To: "Mattias Persson" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, December 31, 2001 4:46 AM Subject: Re: OleDB > This works for me... > > var connectionString = "Provider=MySqlProv; > Integrated Security=''; > Password=1234abcd; > User ID=root; > Location=localhost; > Extended Properties=''; > Data Source=test" > > > Mattias Persson wrote: > > > Anyone know how to write a connectionstring for the OleDB in ASP. I get all > > different kinds of errors when i try to do this. > > I write > > rsDB.ActiveConnection =Provider=MySQLProv; Data > > Source="server=localhost;DB=test" > > > > but it don't work > > > > - > > 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 > > > - > 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 > > - 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
Re: OleDB
This works for me... var connectionString = "Provider=MySqlProv; Integrated Security=''; Password=1234abcd; User ID=root; Location=localhost; Extended Properties=''; Data Source=test" Mattias Persson wrote: > Anyone know how to write a connectionstring for the OleDB in ASP. I get all > different kinds of errors when i try to do this. > I write > rsDB.ActiveConnection =Provider=MySQLProv; Data > Source="server=localhost;DB=test" > > but it don't work > > - > 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 - 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