[c#] sql base to winform, connection string

Question

3.00/5 (2 votes)

See more:

I am trying to connect sql base with my winform app. Base is on sql3.freemysqlhosting.net, i did get next:
- Account number: ............
- Host: sql3.freemysqlhosting.net
- Database name: ............
- Database user: ............
- Database password: ............
- Port number: ............
What is the connection string? I tried this:

C#

SqlCeConnection con = new SqlCeConnection("Data Source=sql3.freemysqlhosting.net;Database=........;User Id=........; Password=.......");

and multiple from this site: http://www.connectionstrings.com/sql-server/[^] and can not figure this out. Get the error, that can not open (connect to) the base.
Any ideas?

Posted 4-Apr-14 9:47am

Member 4347041

Add a Solution

Comments

PIEBALDconsult 4-Apr-14 16:11pm

Could need the port, I suspect they didn't provide it simply for the fun of it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2014-04-04T09:51:00

Solution 1

You will have to ask your hoster.

Posted 4-Apr-14 9:51am

ZurdoDev

Member 4347041 · Answer 2 · 2014-04-04T11:45:00

Solution 2

Now i have noticed, code is for MSSql, but i made a MYSql database. Where can i make MSsql database online for free?

Posted 4-Apr-14 11:45am

Member 4347041

Comments

Member 4347041 5-Apr-14 2:50am

- Is there a way to connect to MYSql with no connector or do you always need to install it?
- If i use connector for mysql from this site: http://dev.mysql.com/downloads/connector/net/
and after app is finished, will my users need to instal the same connector to use my app or it will be integrated in my app's .exe?