View Single Post
 
Old April 8th, 2009, 06:36 PM
allan_ravn allan_ravn is offline
Registered User
 
Join Date: Feb 2009
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Hi again,

Thanks for the links + google searches (which you can also send using www.lmgtfy.com, for example like this: http://www.lmgtfy.com/?q=Books+by+Imar+Spaanjaars).

First I read and installed:
http://www.codeproject.com/KB/databa...pprovider.aspx
(installation went fine, but I haven't tried it out yet as I first want to make sure I can somehow retrieve something from my mySQL database)

Then I realized that I had to install the ODBC MySQL Connector:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

However I did not know how to make VWD "see" the ODBC connector until I found this really great article, about how to setup an ODBC connection to a database:
http://www.depts.ttu.edu/ithelpcentr.../ODBCSetup.php

Now I can actually "see" my database and browse it through the solution explorer in VWD - however I'm not sure if I can just use the GridView control, drag it into an aspx page and bind it to a datatable (called GaveListe in the DB). I tried to do this (using my ODBC connection string) - but when I try to save this in "Save the configuration string to the application configuration file" I get the following error:

Database schema could not be retrived for this connection. Please make sure the connection settings are correct and the database is online. The conncetion has been disabled.
(however I can still press "ok" and get through the GridView guide for configuring the datasource)

But when I try to "run" my application I receive the following exception:

ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[GaveListe]' at line 1
(which I kind of expected as the datasource configuration for the GridView did not complete error free)

Can I do it like I do it? (meaning setup GridView to use my mySQL connection string and still expect to be able to add "UPDATE, DELETE, etc" to the control) - Or do I need to write something more? (note that my DB is currently empty - It's just the table "GaveListe" that I have created without any content).

Br. Allan R