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