Connection string error

[cutepraba]

This code working fine with LOCAL IP not with WAN. can anyone help me abouth this.

Dim con As New ADODB.Connection
conString = "PROVIDER = SQLOLEDB;SERVER=LOCAL IP;UID=XXXX;PWD=XXXX;DATABASE=TESTDB"
con.ConnectionString = conString
con.Open

[randem]

Of course it won't work with a WAN if you use 'LOCAL IP'. You have to actually use an IP Address...

[cutepraba]

yes, i have relpaced with the wan ip but it did not work.

I have referred with connectionstring.com also.

[randem]

Well, look at the obvious things first. I hardly think that a SQL database on the WAN or Internet will have a UserName or XXXX or a password of XXXX...

[si_the_geek]

Thread moved to Database Development forum

Assuming you have changed all the values as apt (ie: replaced LOCAL IP/XXXX/XXXX/TESTDB with whatever is right for your situation), what is the actual problem? (if you are getting an error, what is it?)

[cutepraba]

runtime error: - 2147467259 (80004005)
[DBNETLIB][connectionopen (connect()).] sql server does not exist or access denied.

[randem]

That's like attempting to walk thru a brick wall where there is no door. You will get an error...

All your parameters have to be correct for the database you are connecting too.

[cutepraba]

That's like attempting to walk thru a brick wall where there is no door. You will get an error...

All your parameters have to be correct for the database you are connecting too.

I can connect thorugh LOCAL IP ie 192.168 series(all my parameter is correct). Is this possible to connect with my STATCI IP i just changed the LOCAL IP to STATIC IP????????????

[randem]

Well, your Local database is not on the WAN, it's on the LAN... You have to use the correct parameters for the database on the WAN.

[zynder]

I can connect thorugh LOCAL IP ie 192.168 series(all my parameter is correct). Is this possible to connect with my STATCI IP i just changed the LOCAL IP to STATIC IP????????????

Are you behind NAT? I believe you need to configure port forwarding when using public IP, otherwise the firewall will block outside request.

[randem]

Connect to What???? Doesn't your external database have an IP address or a name that can be resolved to one????

[zynder]

@randem

he want's to connect using public IP. Maybe he's deploying the application outside the network so he'll use public IP. The problem is if he's behind NAT, then it will not allow incoming traffic.

[randem]

That may be so, but the OP hasn't defined exactly what they are doing, where they are running and a host of other thing...

[zynder]

Exactly. Let's wait for the OP for a detailed info.

[cutepraba]

I am using SQL Enterprise edition V 8.0(OS:win2003) and i am very behind the installation and configuration of SQL server. the system has configured with Direct STATIC IP with DNS and GATEWAY. What do you want me to do to working with WAN? please help.
I know only vb.

[zynder]

Read post #10.

[randem]

Matter of fact READ all the post since you last posted!!!!

You are not helping us help you at all...

[cutepraba]

Can someone post some tutorial for (port forwarding) and source codes for VB.

[randem]

Why don't you answer the posted questions first???

[cutepraba]

Why don't you answer the posted questions first???

Hi, Only I need to learn how to working with STATIC IP, in my concern i am not authorized to using my DB in internet. I just want to learn is there any possible to work. And i am very behind NAT concept and routers etc. but i am sure it did not behind the NAT and configured with inbuilt micorosoft network firewall.

Once again i know only VB6 and SQL 8(installtion, backup, restore some basics). So that i asked for the tutorials. if you dont mind can you give me the tutorials.

[randem]

Look at the FAQ's in the Database Forum for a start...

[si_the_geek]

I don't think they will help much - the closest is for SQL Server 2005, but that uses different tools to SQL Server 2000 (which is not known as 8!). I haven't checked, but some of the advice in it might be useful.

Hi, Only I need to learn how to working with STATIC IP

No you don't - that part is exactly the same as you already had with a local IP.

in my concern i am not authorized to using my DB in internet. ..

This is the problem part, but there are lots of reasons why it might be the case, such as:

• the IP address cannot be mapped to the database server.. so try to Ping that address (if it is successful, this is not the issue).
• there is a firewall which is blocking the ports that SQL Server uses.
• the database engine is set up to not allow remote connections.
• ...

[cutepraba]

I have a TEST STATIC IP with me now, and the firewall disabled. Ping request OKAY.

Dim con As New ADODB.Connection
Dim conString As String
conString = "PROVIDER = SQLOLEDB;SERVER=XXX.XX.X.XX;UID=XXX;PWD=XXX;DATABASE=XXXX"
con.ConnectionString = conString
con.Open
Set rs = con.Execute("select sname from names where id1 = 148")
MsgBox rs(0)

So the problem is in "the database engine is set up to not allow remote connections." can you please explain how to set this up?

[si_the_geek]

That wasn't the last possibility, just the last one I wrote out (hence the "..." item).

I don't know off the top of my head how to set it up.. there are instructions for SQL Server 2005 here, but as I said before that is not likely to be very useful - you should try to find a SQL Server 2000 version of the that page.