Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,156,804 members, 7,831,621 topics. Date: Friday, 17 May 2024 at 10:39 PM

Dsnless Connection Across A Network - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Dsnless Connection Across A Network (834 Views)

I Need An It Expert With Knowledge Of Comptia A+, Network+, Ccna, Ccnp / How To Configure Wamp Server On A Network With Windows 8 Operating System / A Site That Requires No Internet Connection To Surf! (2) (3) (4)

(1) (Reply)

Dsnless Connection Across A Network by tomX1(m): 10:58am On Sep 26, 2008
Hi,
in a program I wrote I use the following dsnless connection string to access a dbase on my system

CString m_strConnection = _T("Provider=MSDASQL.1;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\\Program Files\\MySoftware\\mydb.mdb;"wink;
this works fine. Now I am trying to access the same dbase over a peer-to-peer network. The IP address of the system where the database resides is 100.0.0.2 so I used the following connection string but it dosen't work:

CString m_strConnection = _T("Provider=MSDASQL.1;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\100.0.0.2\\Program Files\\MySoftware\\mydb.mdb;"wink;

Does anyone have a good suggestion on how to go about this?
Re: Dsnless Connection Across A Network by tomola(m): 4:59pm On Sep 28, 2008
hmmm pls am sending you this from a cafe and my laptop is at home seriuoly speaking i saw some guys browsing at home, pls can you help me how i can use or connect to the internet? my email is engineerbatu4world@yahoo.com
i will be very happy and glad. PLEASE SEND ME ALL THE STUFF NEEDED TO SETUP MY SYSTEM. THANHS MY BROS
@tomX:

Hi,
in a program I wrote I use the following dsnless connection string to access a dbase on my system

CString m_strConnection = _T("Provider=MSDASQL.1;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\\Program Files\\MySoftware\\mydb.mdb;"wink;
this works fine. Now I am trying to access the same dbase over a peer-to-peer network. The IP address of the system where the database resides is 100.0.0.2 so I used the following connection string but it dosen't work:

CString m_strConnection = _T("Provider=MSDASQL.1;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\100.0.0.2\\Program Files\\MySoftware\\mydb.mdb;"wink;

Does anyone have a good suggestion on how to go about this?

(1) (Reply)

Browse: / Uml And Xml Ebooks Need: Help: / Web Site Design And Software Development

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 9
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.