Newbie -- running sql for samples

Newbie -- running sql for samples

Postby 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.
linda.robinson
 
Posts: 2
Joined: Tue 22 Aug 2006 20:41

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

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

Postby 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?
linda.robinson
 
Posts: 2
Joined: Tue 22 Aug 2006 20:41

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL