Newbie -- running sql for samples

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
linda.robinson
Posts: 2
Joined: Tue 22 Aug 2006 20:41

Newbie -- running sql for samples

Post by linda.robinson » Tue 22 Aug 2006 20:57

Using Trial Version of MySQLDirect.NET for VS 2005 version 3.50.12, on an XP Professional PC, running VS 2005 Professional. Loaded MySql 5.0 on a Windows 2000 server.

I am able to use server explorer to create a connection within VS 2005 to MySql using your software.

Can you provide the next steps for testing your samples applications. I see some quickstart and some sample sql.

Do I need to create a new schema (db), and a new user to run the sql? Which sql should I run? What priviledges does the user require?

The above is probably straightforward to some, but it confusing for a newbie.

I am a very experienced sqlserver and oracle developer, and seasoned VS.NET developer. Need to evaluate your software to determine if my company should buy a site license.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 23 Aug 2006 06:10

Do I need to create a new schema (db)?
Not necessary. You may use existing one.
Do I need to create a new user to run the sql?
Not necessary. You may run the SQL script under existing user.
Which sql should I run?
You need to execute commands from tables.sql to create test data.

linda.robinson
Posts: 2
Joined: Tue 22 Aug 2006 20:41

2nd Step -- How to to run Test solution for [b]VS2005[/b] C#

Post by linda.robinson » Wed 23 Aug 2006 18:37

Above was completed.

How can I run the application samples in VS 2005?

If I double click the C:\Program Files\CoreLab\MySQLDirect.NET2\Samples\Csharp.sln file, it opens in an older version of Visual Studio?

Also, do I need to add my connection string in the web config?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 28 Aug 2006 06:27

You ought to run VS2005 and then open .sln file. Needed sample is to be converted from VS2003 automatically.
You do not need to add your connection string in the web.config file.

Post Reply