|
|
Posted by TerpZebra on 07/19/07 17:26
On Jul 18, 3:50 pm, "William Vaughn" <billvaNoS...@betav.com> wrote:
> Is the firewall open for port 1433?
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speakerwww.betav.comwww.betav.com/blog/billvawww.hitchhikerguides.netwww.betav.com/blog/billvawww.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visitwww.hitchhikerguides.netto get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "TerpZebra" <terpze...@gmail.com> wrote in message
>
> news:1184775545.291016.192510@i38g2000prf.googlegroups.com...
>
> >I am having difficulty connecting to SQL Server 2000 on one of our
> > servers via a VB6 program on Vista. I can connect fine to a different
> > server, but it gives me the following error with the server in
> > question:
>
> > "Unable to connect to database. Please check your internet connection
> > Error# -2147467259
> > [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> > access denied"
>
> > Using the program, I am able to access the database just fine while
> > running on Windows XP, but when I run the program on Vista, it gives
> > me that error message for that server. If I change the connection
> > string to a different server address, it works fine on Vista. What
> > differences in the servers might cause this?
>
> > Here is my connection string:
> > "driver={SQL Server};Server=ipaddress;Uid=userID;Pwd=pwd;database=db"
Yes, it is open for port 1433. I can connect to a separate Server
using the same connection string, except for the IP address, and it
works fine.
I can also connect to both Servers using the application on Windows XP
Navigation:
[Reply to this message]
|