Modem dialup to retrieve data from SQL 2000 Server...

[DengJW]

I am programming a program to use modem dialup to retrieve data from SQL 2000 Server... What would be a good solution for the connection between client pc and SQL 2000 server machine? JW DJ

[Prakash Nadar]

well for fast access you need high speed connectivity, else the process will be very slow for large retrival.

[DengJW]

thank you Mr.Prakash, The concern is the project budget instead of the connection speed as data will not be that big. You also are welcome to read the next message posted by me about this issue. JW DJ

[John M Drescher]

Use dial up networking which is part of windows. Create an incomming connection on the server and a dial out connection on the client. You can have either side create a fixed ip address and get the client to autodial. If you want you can also use MS-CHAP which will give you an encrypted connection. John

[DengJW]

thanks John, But the problem is after a dialup connection established between the PC Client and the DB Server, I could not login through The SQL Query Analyzer which resides on the PC side also. Error message says the DB ( on the DB Server) does not exist or access denied. COuld this be that the OS running on DB Server is Pro instead of win 2k Server? Any other ideas? JW DJ

[John M Drescher]

Did you try to connect to the database using the ip address instead of the machine name? John

[DengJW]

I tried the IP address in SQL QUERY Analyzer. It did not work either. I am trying to access using code: sDSN = "Provider=sqloledb;" &_ "Data Source=TEST\SEAN;" &_ "Initial Catalog=test;" & _ "User Id=sa;" &_ "Password=password" \ thanks DJ

[DengJW]

Thanks a lots. The problem was caused by some OS modules corrupted in Win 2k. I changed to another SQL server on a third machine, now I can access via SQL Query Analyzer and my program. DJ