•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the C# section within the Software Development category of DaniWeb, a massive community of 456,601 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,481 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C# advertiser: Programming Forums
Views: 4370 | Replies: 2
 |
•
•
Join Date: Aug 2007
Posts: 16
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
Remote OLEDB connection with Access 2003 database. hi...
am using access 2003 databse in my application. i want my databse to be on the 1 pc in the LAN. and my application created in c# will be on the all machines in the LAN. So in that application i have made connection string as
" Provider = Microsoft.OLEDB.JET.4.0; server=IPAddressOfTheServer;Data Source= \\ServerName\path of .mdb database file"
if i run my apllication it gives me exception as "Could not find Installable ISAM "
but if i change path to localhost then above string is working.
so can you please tell me above problem or how to access databse on the server from client in above case???????
thanx in advaced.
regards
chaitanya.
am using access 2003 databse in my application. i want my databse to be on the 1 pc in the LAN. and my application created in c# will be on the all machines in the LAN. So in that application i have made connection string as
" Provider = Microsoft.OLEDB.JET.4.0; server=IPAddressOfTheServer;Data Source= \\ServerName\path of .mdb database file"
if i run my apllication it gives me exception as "Could not find Installable ISAM "
but if i change path to localhost then above string is working.
so can you please tell me above problem or how to access databse on the server from client in above case???????
thanx in advaced.
regards
chaitanya.
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 763
Reputation:
Rep Power: 4
Solved Threads: 59
Master Poster
try this http://www.mvps.org/access/bugs/bugs0017.htm if the problem is the same contact me again
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
•
•
Join Date: Aug 2007
Posts: 16
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Re: Remote OLEDB connection with Access 2003 database. hi ....
I got the answer for above and here we go....
The connection string for remote access database is ->
public static string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\Server-PC-Name\\D\\DatabaseName.mdb;Persist Security Info=True;User ID=root;Jet OLEDB
atabase Password=Admin";
look at the '\\\\' in the connection string. the error "Could not find Installable ISAM " might have come because i added only two slashes("\\") instead of four.
second point is that if your server has password then you have to access the remote PC mannually by typing "\\ServaerName" in the run dialog. or direactly access from My Network
Place. Otherwise it wont work.
user name and password in the connection string are the user name and password of the database and not the login for your remote server. you have to access it mannually.
Lets hope this will be usefull for the beginers.
thanx n regards.
chaitanya.
I got the answer for above and here we go....
The connection string for remote access database is ->
public static string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\\\Server-PC-Name\\D\\DatabaseName.mdb;Persist Security Info=True;User ID=root;Jet OLEDB
atabase Password=Admin";look at the '\\\\' in the connection string. the error "Could not find Installable ISAM " might have come because i added only two slashes("\\") instead of four.
second point is that if your server has password then you have to access the remote PC mannually by typing "\\ServaerName" in the run dialog. or direactly access from My Network
Place. Otherwise it wont work.
user name and password in the connection string are the user name and password of the database and not the login for your remote server. you have to access it mannually.
Lets hope this will be usefull for the beginers.
thanx n regards.
chaitanya.
|
•
•
•
•
•
•
•
•
DaniWeb C# Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access adsl adsl1 adsl2 adsl2+ avatar backup breach business cable code combo connection daniweb data data protection database design download dropdownlist environment government hacker ibm internet ip kb kbps mbit medicine microshaft microsoft module ms net network news normalization per remote working reuse security server sql survey testing throughput upload web 240000
- Error in loading DLL (Error 48) in Access 2003 (MS Access and FileMaker Pro)
- direct remote sql connection (Visual Basic 4 / 5 / 6)
- can we connect VB 6 wtih databases in Ms Office Access 2003? (Visual Basic 4 / 5 / 6)
- Upgrading VB4 to VB6 and Database Connection to MS Access (Visual Basic 4 / 5 / 6)
- BDE Alias for ACCESS 2003 User/pwd ?? (C++)
- In which (really) important ways is SQL 2000 better than Access 2003? (MS SQL)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- Remote Desktop Connection (Windows NT / 2000 / XP / 2003)
Other Threads in the C# Forum
- Previous Thread: COM exe server and database
- Next Thread: C# unmanged dll
