Visual Studio and MySQL - Little Help

[0ddball]

Now I know that these two camps are notorious for not getting on properly but I'm using the ODBC drivers and everything SHOULD be working.

The wizards in VS.net 2005 are executing queries against the database which look like this:

devenv          7dc-8b4	ENTER SQLExecDirectW 
		HSTMT               0FE81FE0
		WCHAR *             0x01C4A76C [      -3] "SELECT * FROM `ecommerce`..`addresses`\ 0"
		SDWORD                    -3

devenv          7dc-8b4	EXIT  SQLExecDirectW  with return code -1 (SQL_ERROR)
		HSTMT               0FE81FE0
		WCHAR *             0x01C4A76C [      -3] "SELECT * FROM `ecommerce`..`addresses`\ 0"
		SDWORD                    -3

		DIAG [23000] 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 '.`addresses`' at line 1 (1064)

That's from the ODBC trace file as the queries are generated automagicly by VS. Of course the thing isn't going to work - I'm not certain but I'm pretty sure that putting two periods in there is the wrong sytax. Deos anyone know why this happens or how to stop it?

The easyest thing I've come across so far is to just hack the ODBC driver to filter out the double periods. I've not done that yet because I'm certain there has to be another way.

Someone know's it - I have faith in you all.


Yet another unchecked rambling brought to you by:
Oddball

 

[KarveR]

This was handy last time I tried.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1288&lngWId=10

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[0ddball]

That's just the thing you see.

I've been coding for a long time use just code and not the wizards and stuff. I am, however, starting to feel a little left out.

I would like to make MySQL work in VisualStudio like a normal Data Source.

I can write it in the code but I don't want to - I want to save time and money and use the designer!


Yet another unchecked rambling brought to you by:
Oddball