How to connect to Sql Server

Dear Sir and Madam:
I am now using Visual Foxpro 8 connect to MS Sql server 2000 (Personal Edition).
Now, I have a serious problem that I can not connect SQL Server from client machine and it raises the following message :
SQL Server does not exist or access denied

But it worked when I connect at Server. I don't know the reason why

Here is My Server Configuation
Computer Firewall is OFF
Authentication : SQL Server and Windows
Connectstring="DRIVER=SQL Server;SERVER=HUNG1975;DATABASE=sales;UID=sa;PWD=sa;Trusted_Connection=False;DispLogin=3;ConnectTimeout=3"

Please help me
Thank you very very much.

Hi,

make sure that you are using the right port and that the user and the password is valid can access the database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

How to conncet two PC's to share SQL server database using VB

Sir,

I am a beginer to SQL Server, as well as to networking. I have a VB program to manage a SQL server database.
I need to share database informations using a second PC. Both PC's are installed with network cards and connected with a cross network cable.

Now I need to configure the two PC's to share information and to send reports to a printer.

Pl help me to solve this problem anyone who knows.

Thanks.

Kusman

Quote:

Originally Posted by kusmanf

Sir,

I am a beginer to SQL Server, as well as to networking. I have a VB program to manage a SQL server database.
I need to share database informations using a second PC. Both PC's are installed with network cards and connected with a cross network cable.

Now I need to configure the two PC's to share information and to send reports to a printer.

Pl help me to solve this problem anyone who knows.

Thanks.

Kusman

that's mater of databse connection

you can use DSN connection to solve ur prob