Hi, I am new in .Net framework. Currently I am having problems connect to another server with VB
.Net to MS Access database. I read similiar articles in this forum about the connection string to connect to Access but still failed. I do not know what's wrong.
My situation is that, currently there is a database file named DATA1 in SERVER1. This DATA1 is currently connected to another software called SOFTWARE1.
I copied DATA1 into my local harddisk and with the WebApplication(ASP .Net Web Application in VB
.Net), which only retrieve info from DATA1 and display it in the forms. The connection is successful, with the connection string such as below:
Dim cn As New OleDb.OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DATA1.mdb;")
After finish testing, and wanting to connect to the DATA1 on SERVER1(Server1 is mapped as drive E:), I can't connect to it. I tried a connection string as below:(User ID with a blank password)
("Provider=Microsoft.Jet.OLEDB.4.0;Server=E:\DATA1 .mdb;User ID=Admin;Password=;")
*This give me an error of--Could not find installable ISAM.
Then, I tried connect to DATA1 using VB
.Net through the server pool, and the connection was successful tested and linked. Therefore I copied the exactly connection string from the "property" such as below:
("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\DATA1.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False")
*This give an error of--Format of the initialization string does not conform to specification starting at index 146.
There is no *.mdw in SERVER1 too, I does not know what went wrong, your help will be much much appreciate, I had been trying to find the answer for almost 2 days :