Impressed with MSDE

S

sjn78

Junior Contributor
Joined
May 4, 2003
Messages
255
Location
Australia
So, I finally did it...went from access to msde. The speed increase on retrieving and inserting data is huge. Found that the time it takes to pull back 1000 records from msde is the same as it takes to even open an access connection and pull back 1.

One question though, is it possible to do this...

Have installed the msde database on my pc. It is networked with 2 other pcs using a router and have the internet connection plug into the router also. I have managed to get the other pc's reading the database, but can someone outside the network, eg you, gain access to the database?

I have tried setting up norton to allow connections to the database on the appropriate socket and same with the router, but its still not going. My connection string has the IP address of my PC to give it a direct path to the database.

I know this should be possible, but where would be the best place to start looking on doing this type of setup.

Thanks
 
Yes. . .

You will have to route IP traffic through your router to the SQL server for the SQL server ports.

there are two SQL server ports. one for listening and one for actual data, I believe.

You can configure the second, but can't change the listener.

BTW. . . this is why I don't understand what the big push for ASP.NET based applications in 9 out of 10 internal scenarios.

People think Web Based means it has to run in a browser.
granted, it means you have to open your firewall to the sql port.
 
Joe Mamma said:
BTW. . . this is why I don't understand what the big push for ASP.NET based applications in 9 out of 10 internal scenarios.

People think Web Based means it has to run in a browser.
granted, it means you have to open your firewall to the sql port.
Click to expand...

You mean just using a WinForms solution to connect directly to the database/host app?

I keep thinking about ASP.Net and liking the concept. Then I go to use/learn it and I start to groan.

I guess it's good for multiplatform utility within a company, or internet programming.

The bank I interned at used to do inhouse programming in VB6, then outsource ports to linux and some other secure server OS and give them the vb6 code to go off of :) I'm sure that would make your head explode Joe :D

Just having ASP.Net and making the app once on the server would be soo cost/time effective.
 
I tried that port first of all without any luck. Maybe its my router settings. You can let one computer have direct access to the internet by specifying the ip address so that the inbuilt firewall won't stop any traffic. Tried this as well without any luck.

Funny thing is that Norton keeps picking up 'Attacks' from other computers thoughout the day from computers I have no idea of whose they are.

I will keep playing around with. Must be a setting a haven't seen yet.
 
Back
Top