Virtual connection to a Access Db
-
I need to make a connection from a c# application running locally on a PC to a MS access db running on a web server with. Essentially, I would like to use something like string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.domain.com/db/mydb.mdb;"; Any suggestions would be great. Almerica
-
I need to make a connection from a c# application running locally on a PC to a MS access db running on a web server with. Essentially, I would like to use something like string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.domain.com/db/mydb.mdb;"; Any suggestions would be great. Almerica
-
Is there a way to update it then without actually having a script on the server? I hear you can do it with a Sql DB. Almerica
Almerica wrote:
Is there a way to update it then without actually having a script on the server?
Nope.
Almerica wrote:
I hear you can do it with a Sql DB.
SQL is the language that you use to query the database, it has nothing to do with how you connect to the database. Access also uses SQL. I suppose that you mean Microsoft SQL Server. That is a database server, in contrast to Access that is a file based database. You can connect to a database server from anywhere, but for a file based solution you need direct access to the actual file.
--- b { font-weight: normal; }
-
I need to make a connection from a c# application running locally on a PC to a MS access db running on a web server with. Essentially, I would like to use something like string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.domain.com/db/mydb.mdb;"; Any suggestions would be great. Almerica
Hi Almerica. First, has you been thinked that if the Virtual connection to a Access Db was possible do you really want make it?. Remember this, When you open a Microsoft Access DB with OleDb, this block the file for other users. Why don't try using Free DataBases like MySQL. I'd suppouse that these have more powerful that Access.
SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
-
Hi Almerica. First, has you been thinked that if the Virtual connection to a Access Db was possible do you really want make it?. Remember this, When you open a Microsoft Access DB with OleDb, this block the file for other users. Why don't try using Free DataBases like MySQL. I'd suppouse that these have more powerful that Access.
SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
-
Thanks everyone for the advice. It sounds like the best thing for me to do is to go with SQL Server. I have hosting with godaddy and they offer SQL Server. :-D
-
Hi Almerica. If you really need do it with Access, You can do it with WebServices, sending XML to client.
SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?