Newbie needs help

  • Thread starter Thread starter clayton.curmi
  • Start date Start date
C

clayton.curmi

Hi everyone,

I'd like to access a database using C#. I've installed the Visual
Studio 2003 and mysql essential and mysql administrator. On Visual
Studio I go on server view and right click on SQL Servers, then I click
on Register SQL Server Instance. It will prompt me to enter the
instance name and login information but I'm getting this error -
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or
access denied. I'm sure that my username and password are correct. The
only thing I'm not sure of is the instance name? Is the instance name
the same as service name - such as MySQL in Services? Any help?

Thanks,
Clayton
 
Hi Clayton,

If you are going to connect to Non-MS SQL Server, you have to use "Data
Connections" in the "Server Explorer" instead. Please also make sure that
you have the OLEDB provider for mySQL.

Raymond
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Connecting to an SQL Server from Excel 2007 1
SQL server vs mySQL ??? 5
MySql .net ADO - How to use with VS2008 5
Problem remoting to SQL Server from a Vista Machine 1
sqlcmd error 1
DataRelation left outer join different database types 4
Database Connection Problems 2

Back
Top