connection-string

Most reliable solution to determine whether to use ACE or OLEDB in connection string?

I'm handed a path of an access 2000(/2003 (edit)), or access 2007 database: C:\database.mdb or C:\database.accdb I have to determine a suitable connection string, using either ACE or JET, to connect to the database. I was wondering whether parsing the last part of the string and determining whether it is mdb or accdb is guaranteed...

visual foxpro connection string

hello, i have to extract some data from a foxpro database. I found a sample app that extracts data from a sql server db and stores the connection string in the app.config file in the following format - <connectionStrings> <add name="test" connectionString="Data Source=localhost\SQLExpress;Initial Catalog=test;Integrated Sec...

Accessign Local Sql Ce with a Local Wcf Service

I am using Sync Framework in SL App to sync Sql Server and local SqlCe DB. Having problem in connecting to Sqlce. Getting an Exception here new SqlCeConnection("http://localhost/Sample.sdf"); Error: ArgumentException was unhandled by user code. The connection object is not valid. Cannot create a new instance of the connection object."...

problem connecting to mysql from vs2010

Hello, I am trying to connect to mysql using c# in vs2010. I installed the 6.3.5 version of the .net connector from the mysql site. I try using the following connection string - <add name="mySql" connectionString="Server=localhost;Database=mydb;Uid=User;Pwd=mypass;" providerName="System.Data.OleDb.OleDbConnection, System.Data, Versio...

visual foxpro database connection issues

Hello, I am putting together an application that connects to a vfp database. I have it working fine if I define my connection string in the app.config file - <add name="vFoxProSource" connectionString="Provider=vfpoledb;Data Source=C:\directory\database.dbc;Collating Sequence=machine;" providerName="System.Data.OleDb.OleDbConnection, ...

How to validate the connection string comming from a text file

there is a way by which we parse any time input given by user... here i am taking the input of a connection string from a text file i am supposed to assume that the user who keeps this string in the text file can be trusted. but what if he makes a typo a mistake unknowingly, that will cause the coming code to cause exception, i would...