CONNECTSTRING & DATASOURCE problem

[LARRYVINCI]

Hello to all! Hopefully someone can help. Im new to activex controls. heres the problem, I created a activex control and inserted it in a web page. It only contain a msgrid and data control using the jet3.5. I don't know how to set the CONNECT STRING to my webserver. It runs fine on a local network but when I register the control at work and try to run it from the internet, it says not a valid path?? It keeps pointing to c:. Any help would be great.
Thanks
Larry

[amitabh]

It would be much better if you could post your connection string.

[LARRYVINCI]

Hello Amitabh. Thanks for replying. Below is the connection string that works fine over the network. But is it even possible to use this over the Internet? I am brand new to this stuff. I may be way off base here. The goal is that I need to view a database from my house with many fields. I wrote in asp and it works fine. I want to use a grid. The grid comes up but with no data. it keeps looking for it on my pc where I registered the active x not on the server?

this is from the property of the adodc1 control

Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=\\pcname\tt\dbP1.mdb

Any help would be great!!
Larry

[amitabh]

No. this won't work through Internet. The path that you are specifying \\pcname\tt\dbP1.mdb is valid only over a network. To work over a domain, you need to specify a fully qualified domain name like www.vbforums.com. The database must reside on some computer thats permanently connected to the net, and is accesssible by the everybody.

[LARRYVINCI]

OK, but when I try to give it a domain name no data shows up & I get an error cause its looking in c:
Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=http://test.com/dbP1.mdb
Can you even do something like this anyway? Im Blown out!!!

I really appreciate your help with this. I may be way off from what Im trying to do. I'll keep trying. Any guidence would be great.
Thanks
Larry

[amitabh]

What is test.com? Do you own this domain name over the internet? I suppose you are confused in the terminoligies used.
Lets start from the base:
To connect to a database that's in your home PC, you need your home PC to be permanently connected to the internet, and be accesible to the outside world.
Non-technical explanation of the domain-name system (http://www.internic.net/faqs/authoritative-dns.html) .

Also, to connect directly to the databse, you will need SQL Server rather than Access. For connecting to Access, you will nead to create your own database wrapper server.

The best thing you can do first is to determine whether you are permanently connected to the internet. You can either check with your ISP, or try this method:
1) Click on this link (http://whatismyip.com) to know your true URL.
2) Go to Dos Prompt and type IPConfig to determine your systems IP Address.
If both are same, then your are connected to the internet and can use your computer, otherwise you need to host your database on a web server.