Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Connection String from Sql Server 2005
Thread ID: 365271 Message ID: 365296 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 24, 2012 2:57:03 AM         
   


> >
> > The following string is not working and showing error
> >
> > cStr = "Driver={Sql Server};Server=.;Database=Malik13;Trusted_Connection=Yes;"
> > mConn=SqlStringConnect(cStr)
> >
> >
> >
> >
> > Rgds:
> > Ahsan Rana
>
>
>
> Here an example of an ODBC connection string:
>
> Driver={SQL Server Native Client 10.0};Server=myServerName\theInstanceName; Database=myDataBase;Trusted_Connection=yes;
>
> Notice the space after each ; in the string
>
> What version of SQL Server are you using. Do you know the server name. Do you know the instance name?
>
>
> -Anders

"The space after each ; in the string" ???? What does it have to do?



Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down


Support Wikipedia

ENTIRE THREAD

Connection String from Sql Server 2005 Posted by Ahsan Rana @ 12/23/2012 4:44:09 PM
RE: Connection String from Sql Server 2005 Posted by Michel Levy @ 12/23/2012 4:46:53 PM
RE: Connection String from Sql Server 2005 Posted by Ahsan Rana @ 12/23/2012 5:02:58 PM
RE: Connection String from Sql Server 2005 Posted by David Mustakim @ 12/23/2012 6:13:00 PM
RE: Connection String from Sql Server 2005 Posted by Ahsan Rana @ 12/24/2012 3:21:35 AM
RE: Connection String from Sql Server 2005 Posted by Michel Levy @ 12/23/2012 6:15:58 PM
RE: Connection String from Sql Server 2005 Posted by Ahsan Rana @ 12/24/2012 3:11:58 AM
RE: Connection String from Sql Server 2005 Posted by Anders Altberg @ 12/23/2012 6:30:02 PM
RE: Connection String from Sql Server 2005 Posted by Cetin Basoz @ 12/24/2012 2:57:03 AM
RE: Connection String from Sql Server 2005 Posted by Cetin Basoz @ 12/24/2012 3:24:09 AM
RE: Connection String from Sql Server 2005 Posted by Ahsan Rana @ 12/24/2012 4:31:45 AM