This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I am attempting to connect to a MySql database using LightSpeed as well as the published 2.5.2 driver from MySql to allow SQL databases to be selected as a data source. The following is the error I get: "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 set up my connection strings via app.config, which is as follows: <?xml version="1.0" encoding="utf-8" ?> I have tried using several different providerNames, and have made sure that all of the appropriate references to the MySql.Data have been made in the project. I don't know why I am connecting to a MySql database (via Server Explorer), dragging the appropriate tables into the .lsmodel, setting up the connection (see above), and getting an error saying that I am attempting to use SQL Server. I am using MySql 5.1 and VisualStudio 2008. Thank you for any help you can provide. |
|
|
Hello PwgGroup, Hmm, your config file seems to be fine, but it sounds like the LightSpeedContext.DataProvider is not being initialised -- but that the ConnectionString is (otherwise you'd be getting a different error). Can you show us how you are initialising the LightSpeedContext object e.g. is it LightSpeedContext context = new LightSpeedContext(); LightSpeedContext context = new LightSpeedContext("default"); LightSpeedContext context = new LightSpeedContext { Thanks! |
|