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 |
|
maxim
Yak Posting Veteran
51 Posts |
 Posted - 2007-07-09 : 11:35:07
|
| Hello!I have a site hosted into a hoster company and i want to upload an asp.net application that retrieves my fields from online database and inserts they into my local database!!Notes:My application will run on my hoster server!My connection string for online database will be:server=whsql-v12.prod.mesa1.secureserver.net;database=DB_xxxxx;uid=*myUserName*;pwd=*mypass*But I don't know what connection can I use to connect to my local database under this online application!If the application is on my localwebfolder I use:server=MYSERVER;database=myDatabase;uid=sa;pwd=;I assume that I need to put my ipaddress somewhere but do I need to make some changes into my windows firewall?Thanks!Max |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-09 : 14:59:46
|
| Ensure your hosting company let you do this. |
 |
|
|
maxim
Yak Posting Veteran
51 Posts |
Posted - 2007-07-09 : 15:57:33
|
| ??Did you read all my post?I want to make an application to upload to my hostercompany, connecting my onlineDB and my LocalDB!The only one who can allow/deny external connections his me! Am I right?If I give to you my local database password, ip, etc, you don't need authorization from anyone to enter here e retrieve some data!Or not? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-09 : 16:38:24
|
| Not really, you can't connect to hosting company's sql server directly or connect to outside sql server from hosting company's server if they block the port. |
|
|
|
maxim
Yak Posting Veteran
51 Posts |
Posted - 2007-07-09 : 17:02:06
|
| I give up! Nobody read my posts!I already connect directly to the sql server from my hosting company when my application are online!I want to make an application, put it online, connect to the myhoster sql, and connect it too to my local(my pc... my machine) sql server!If my application are online, I don't need my hoster company to open ports because they are already open for their databases!But I want to connect from there to my local database too!!I just want to know if I have to open one port... Where do I put my Ipaddress in that application, etc etc...But I don't speake same language than you!Thanks! |
|
|
|
maxim
Yak Posting Veteran
51 Posts |
Posted - 2007-07-09 : 17:08:22
|
| If I open my port, give you my IP, ServerName, UserName, Password, couldn't you make an application in Asp.Net, host her somewhere and retrive some data??????????Unless i'm crazy!!!!!It's that i'm trying to say!I have my my IP, ServerName, UserName, Password. I want to know how can I use this(to make a connectionString) to make an application, put it online, and transfer my onlineDB to my localDB!I just have my application done!I can connect to the source database!I just need to connect to the destination database (my sql database from my pc = localDatabase) |
|
|
|
|
|
|
|
|
import export database