MS Access Connection String
-
Hi all, How do I connect to a MS-access data base which is present in localhost from an application runnig on web server. I want to send data from DB Server (sqlserver 2000) which is on remote machine to Ms-Access DB present in localhost. After googling I found the following Open connection to Access database located on a remote server:
"Provider=MS Remote; Remote Server=http://Your-Remote-Server-IP; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb"
But, here my localhost IP varies depending on the client's system on which the web application is running. So, how do I set the clients' IP value or is there any other way to acheive this. Thank U all, Kiran
-
Hi all, How do I connect to a MS-access data base which is present in localhost from an application runnig on web server. I want to send data from DB Server (sqlserver 2000) which is on remote machine to Ms-Access DB present in localhost. After googling I found the following Open connection to Access database located on a remote server:
"Provider=MS Remote; Remote Server=http://Your-Remote-Server-IP; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb"
But, here my localhost IP varies depending on the client's system on which the web application is running. So, how do I set the clients' IP value or is there any other way to acheive this. Thank U all, Kiran
try this... Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server_name\db_folder\Your_Database_Name.mdb;User Id=admin;Password=;
-
try this... Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server_name\db_folder\Your_Database_Name.mdb;User Id=admin;Password=;
Hi Jack, Thanks for ur response. But my actual requirement is as follows.., I uploaded an application to remotely located web server. Whoever the client calls that application it needs to send the content of its sqlserver database to clients' ms-access database. For this I need to establish a connection in that web-application to have access to clients' MS-Access data base. Irrespective of the connection i.e., whether it is from a proxy, Dial-Up, Broad band the data should flow exactly to the clients' system who is currently using that application. So, How do I know the exact systems' address to copy the database? Thank U all, Kiran.
-
Hi Jack, Thanks for ur response. But my actual requirement is as follows.., I uploaded an application to remotely located web server. Whoever the client calls that application it needs to send the content of its sqlserver database to clients' ms-access database. For this I need to establish a connection in that web-application to have access to clients' MS-Access data base. Irrespective of the connection i.e., whether it is from a proxy, Dial-Up, Broad band the data should flow exactly to the clients' system who is currently using that application. So, How do I know the exact systems' address to copy the database? Thank U all, Kiran.
I think you are trying to PUSH (from SQL Server to Access) when you do not know where the Access DB is. This requires telepathinc software OR have your app/access db tell SQL where it is before trying to push.
kadkir wrote:
Whoever the client calls that application
As part of the call make it identify itself. IIRC you used to be able to link an Access DB to use sql tables, this implies a connection residing in the Access DB!
Never underestimate the power of human stupidity RAH