Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: marcel
  Where is marcel?
 kl
 Malaysia
 marcel
 Tags
Subject: connect to msde with vfp
Thread ID: 210100 Message ID: 210100 # Views: 42 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, January 03, 2009 10:34:23 AM         
   


Dear All
Merry christmas & happy new year

I installed msde (mssql 2000) into windows 2000 server.
In my application I wrote
cc="driver=SQL Server;server=MyServerName;database=MyDatabase;trustedconnection=Yes"
nMyConnection= SQLSTRINGCONNECT(cc)

it works just fine at windows 2000 server, but when I run my application
at client (windows Xp) it returns error (
connection failed:
sqlstate:'01000'
sqlserver error:53
[Microsoft][ODBC Sql server driver[DBNETLIB]Connectionopen(connect())
bla bla bla

Please advise how to deal with this issue
best regards
marcel



COMPLETE THREAD
connect to msde with vfp Posted by marcel @ 1/3/2009 10:34:23 AM
RE: connect to msde with vfp Posted by Olaf Doschke @ 1/3/2009 12:49:36 PM
RE: connect to msde with vfp Posted by marcel @ 1/4/2009 5:07:14 AM
RE: connect to msde with vfp Posted by Borislav Borissov @ 1/4/2009 1:21:50 PM
RE: connect to msde with vfp Posted by Olaf Doschke @ 1/5/2009 10:33:41 AM