Page 1 of 1

Newbie -- running sql for samples

Posted: Tue 22 Aug 2006 20:57
by linda.robinson
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.

Posted: Wed 23 Aug 2006 06:10
by Alexey
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.

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

Posted: Wed 23 Aug 2006 18:37
by linda.robinson
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?

Posted: Mon 28 Aug 2006 06:27
by Alexey
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.