Impressed with MSDE

[sjn78]

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 pcs 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

 

[Joe Mamma]

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 cant change the listener.

BTW. . . this is why I dont 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.

 

[Denaes]

BTW. . . this is why I dont 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.

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 its 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 Im sure that would make your head explode Joe

Just having ASP.Net and making the app once on the server would be soo cost/time effective.

 

[Derek Stone]

Youll need to enable TCP port 1433.

 

[sjn78]

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 wont 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 havent seen yet.