Connection String VS

snowboarder · **Joined:** Thu 12 Nov, 2009 16:55 **Posts:** 3

I'm trying to connect my Visual Studio application with my db4free database, using a connection string in app.config.

I used the following Connection String:

Quote:

<add name="DBconnection" connectionString="server=db4free.net;user id=<USERNAME>;Password=<PASSWORD>;persist security info=True;database=dvdlijst" />

When i debug the application, I get the following error:

Quote:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I already downloaded the MySQL Connector and added a reference to it in my application..

What am I doing wrong??

mpopp

Hi,

can you connect through other means, like another MySQL Client (e.g. MySQL Query Browser) from the same host on which you run your application? It may be a permission issue, unless you set the allowable host to "%" for your account.

Cheers,
Markus

snowboarder · **Joined:** Thu 12 Nov, 2009 16:55 **Posts:** 3

In phpMyAdmin I got the following messages at the bottom:

Quote:

The additional features for working with linked tables have been deactivated. To find out why click here.

Quote:

Your PHP parameter session.gc_maxlifetime is lower that cookie validity configured in phpMyAdmin, because of this, your login will expire sooner than configured in phpMyAdmin.

But I can exucute queries in phpMyAdmin on my database.

When I use MySQL Administrator and I connect to server: db4free.net with my username/password and go to 'User Administration', I got the following message:

Quote:

A MySQL error was encountered. The message is:
Could not fetch user names.
The following error occured: SELECT command denied to user 'snowboarder'@77.249.232.238' for table 'user' (1142)

When I signed up for database, I changed nothing to allowable hosts.. so it should be '%'..

Any solutions for this?

snowboarder · **Joined:** Thu 12 Nov, 2009 16:55 **Posts:** 3

Nvm.. I already found the problem
My connection string in app.config didn't make any sense -.-

mpopp

Nice to hear it works

.

Cheers,
Markus

Connection String VS

Who is online