Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: yaser awwad
  Where is yaser awwad?
 amman
 Jordan
 yaser awwad
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: How to connect to Sql server 2000 throug
Thread ID: 268438 Message ID: 268883 # Views: 25 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 8:14:58 AM         
   


hi every body

I use this code to connect to sql server 2000 in my local network on the company

public cnn as ADODB.Connection
cnn = CREATEOBJECT('ADODB.Connection')
Try
dsn1="Driver=SQL Server;Server=instructor;WSID=instructor;uid=ya;pwd=ya;DATABASE=Cola"
cnn.ConnectionString =dsn1
cnn.Open()
MESSAGEBOX("connection OKI..",32,"Connection")
CATCH TO oErr
MESSAGEBOX("connection Failed..",32,"Connection")
ENDTRY

but it can not connect from another area through the internet

pls help me
thanks alot

ENTIRE THREAD

How to connect to Sql server 2000 throug Posted by yaser awwad @ 7/12/2010 9:56:53 AM
RE: How to connect to Sql server 2000 throug Posted by tushar @ 7/12/2010 10:04:20 AM
RE: How to connect to Sql server 2000 throug Posted by yaser awwad @ 7/12/2010 10:07:10 AM
RE: How to connect to Sql server 2000 throug Posted by tushar @ 7/12/2010 10:31:53 AM
RE: How to connect to Sql server 2000 throug Posted by yaser awwad @ 7/15/2010 8:14:58 AM
RE: How to connect to Sql server 2000 throug Posted by Cetin Basoz @ 7/12/2010 11:32:26 AM