Just starting to use the sql express edition with vb2005. weard stuff as compared with the access desktop stuff,
Have figgured out that sql will need to be running before a connection can be made. It is set to start manually currently, I hate anything starting without knowing it's running. OK so now I 'add' a new item to the project ie SQL Database.. and my Norton fire wall just gets nuts with outbound warnings telling me ... vbexpress.. etc needs to find a DNS server 69.66.0.20 .53.. do I want to allow ... HE>> no ..
SO why does vbexpress/sql server need to pop some DNS server on the internet before it will work.. how can I set up SQL/vb so this won't happen
Some of the machines this app is going to be setup on WILL NOT HAVE an Internet connection ever... shop computers only connected to machines they control They maybe connected to a local network someday but will not be able to get anywhere close to the internet..
Help
stubs
getting vb and sql 'express' editions to work..together...
meowbaby7
Yes I guess that I figgured it out about two hours later.. What seemed to confuse me was after blocking the DNS lookup at the firewall VB did not act like it wanted to connect to the SQL server. It was though, I just didn't understand yet how to be able to 'see' it'.
Thanks
stubs
gordon LI
Sounds like that is your DNS Server that your computer uses to connect to the internet.
When VB tries to connect to an SQL Server it'll attempt to use the DNS server to resolve the name of the SQL Server you want to connect to. You will have to understand that if you want to connect to a remote database on your network, the programs need to communicate over the network - you will have to allow these programs to go through the firewall. This does not necessarily mean the need INTERNET access. To reiterate, YOUR computer is set up with those addresses, so VB will use those addresses.
Even so, VB Express and SQL Server Express are designed to work on the same machine. If this is such a case, you can quite happily block anything from being sent out (Alternatively, setup your hardware firewall to block such outgoing messages).