Internet connection

[knightrader]

it's possible to open a db and make an SQL query wich, instead of being in you hard drive ou in your LAN, is in a web server (over an internet) ?

thanks

 

[Terpsfan]

Yes, you can either run a static HTML page that displays query results, or use a dynamic HTML/ASP page that displays results as they are updated through time intervals. I'd suggest you get a good book on Active Server Pages. SQL Server integrates very well with ASP.

 

[knightrader]

Omega36

what I mean was: I need to open a db on a local database and get some values, then I ned to open a db, wich is in a webserver, and insert the values there. I also need to repeat this process every 15 minutes.

Do you know how can i make this?

thanks

 

[Antzz]

Yeah this is absolutely possible. If you are familiar with ASP(as Omega mentioned), you should not have any problems doing it. You can open up two separate connections to two different databases located at physically separate locations and do you processing as you want.

 

[knightrader]

Antzz

I'm making a web site using ASP, I open a database in my web server using ODBC. However, ODBC only allows me to connect to databases that are over a LAN, if the db is located over the internet I think it's not possible. Any way, if you know how to do a internet connection, can you explain me a little more? I really apriciate.

Thanks

Nuno N.

 

[Antzz]

If it is a database on the Internet, then the first thing you need to do is see how you can have access to the server machine. You will need to register the remote server on your own server where you are planning to execute your scripts.

Is the database a SQL Server or Oracle?

 

[knightrader]

Actually, i'm using Access2000. I still don't understand how it's possible to do that. My case is the follow: I have a db at my office and I want that every 15 minutes a vb program get the data and insert into a similar db that is located on a web server. I want to be able to do this by and ODBC connection, instead of create a txt file and use ftp to send it to the server.

Do you think this is possible?

thanks once again

Nuno N.

 

[Antzz]

Is the database on the webserver Access too?

 

[knightrader]

yes, the web server is running with windows 2000 advance server and the db is Access 2000

 

[rroque]

Do the following:

1. The web server has to have an ODBC connection to the SQL server. This is done locally on the web server. Setup an DSN.

2. Your application will refer to the ODBC DSN.