| Author |
 Topic  |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 24 September 2004 : 19:04:07
|
I'm learning .NET little by little using Microsoft's free Web Matrix program.
Now I want to use MySQL as my database backend, but I am not sure how to connect to mysql from my aspx page. MySQL has a .NET driver in beta (http://www.mysql.com/products/connector/net/), but there are no instructions on what i should do with it, apart from installing it.
Anyone got any clue? |
Support Snitz Forums
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 September 2004 : 21:05:58
|
Thanks Podge. But that product isn't free. Unless you wouldn't mind buying me a copy. I would be greatful.  |
Support Snitz Forums
|
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 25 September 2004 : 05:05:26
|
I've been using ByteFX which I believe is what that beta from MySQL is based on.
If you put the *.dll files in your .NET bin (Windows/Microsoft.NET/...) folder then the class browser that came with the WebMatrix should display them. -- I might be a little off here because VS.NET works a little differently.
|
 Nathan Bales
CoreBoard | Active Users Download |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 September 2004 : 06:08:48
|
The .NET bin? Which folder in the Windows/Microsoft.NET/ folder is the bin?
/Windows
- /Microsoft.NET
-- /Framework
--- /v1.0.3705
--- /v1.1.4322
---- /1033
---- /ASP.NETClientFiles
---- /CONFIG
---- /MUI
---- /Temporary ASP.NET Files
---- /Updates
There are a few more folders in those, but I don't see any bin folder. |
Support Snitz Forums
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 25 September 2004 : 11:45:58
|
/v1.1.4322
with VS.NET I could put it in my projects bin folder, but I don't know if thats going to work for the Web Matrix |
Nathan Bales
CoreBoard | Active Users Download |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 October 2004 : 22:22:48
|
| So Nate, how do I connect to my mysql database from my aspx pages, using this connector? |
Support Snitz Forums
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 October 2004 : 07:16:46
|
It works just like the connectors for MSSql and Access OLEDB provided by Microsoft.
Check out the quickstarts on data access, then add a "My" in front of every "Sql".
The funcitons arn't a perfect match, but they are close enough. For example there are some functions in the Access provider that that return you schema information. The MySQL providers dont have that tidbit.
|
Nathan Bales
CoreBoard | Active Users Download |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 October 2004 : 07:23:31
|
| And if you have trouble with it still, feel free to IM me anytime I'm on. |
Nathan Bales
CoreBoard | Active Users Download |
|
|
| |
Topic |
|
Topic Locked
