Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-28 : 08:04:08
|
| Winston Suarez writes "I am trying to connect my sql server over the internet with a program i created on (vb 6.0) i am using the Adodc1 driver from vb. here is my formula i am trying to use to connect to my sql server. With Adodc1 .ConnectionString = "driver={SQL Server};" & _ "server=46.154.111.196;database=SQLExclusive" .RecordSource = "SELECT * FROM SWeekly order by Numbers" End With Adodc1.Refresheverytime i try to read my server over the internet give me an error.the about ipaddress showing in the code is a sample." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-28 : 09:03:23
|
| See if this helps youwww.ConnectionStrings.comMadhivananFailing to plan is Planning to fail |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2005-10-28 : 18:38:59
|
| It may be that the person(s) on the other end are wise enough to *not* just expost port 1433 (OLEDB) to just anyone over the internet. You may need them to update their firewall settings, or get you on a VPN.Cheers-b |
|
|
|
|
|
|
Connecting Adobc with SQL Server over the Internet