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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  ODBC Connection

Author  Topic  ragh Starting Member 34 Posts Posted - 2003-07-23 : 00:21:28 Hi all ! I will give the scenario, can you please help me how i can achieve this: 1. I have a webserver which has some webpages and SQL Server 2000 databases located almost 100 kms away from me. 2. I have my PC which has access to Internet connection, I have a program that must use this database to fetch records (from Webserver) and read out. 3. The entire picture i have given here is about CTI IVRS. 4. The Caller will give a call thru local phone and my application located in a local machine will receive the call and then it must connect to remote PC where the SQL Server Database is located and read out the results for the caller. Now, am i able to use ODBC and connect to Remote Database if so then please let me know how? I'm using VC++ and SQL Server 2000. please help me immediately. do provide me some steps and tips..! regards and thanks in advance Raghavendra Ragh