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
 
Back
Top