CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 SQL Server 2005 Connection String for CCS 4.2

Print topic Send  topic

Author Message
jpbconsulting

Posts: 1
Posted: 08/10/2009, 2:17 PM

CCS 4.2

What connection string (procedure) is necessary to connect CCS to a MS SQL Server 2005 running on Windows Server 2003 via IP. The IIS destination server is on the same box. I know this question has been asked on the forum before, but there are no answers to be found.
View profile  Send private message
peterr


Posts: 5971
Posted: 08/13/2009, 12:53 AM

Hi,

I just click "Build" , select OLE DB Provider for SQL Server, then enter the same info as in MS SQL Server Manager (or copy it from MS SQL Server Manager). Then the program builds the connection string automatically, so I don't have to remember the structure.

This way I also avoid any problems because if I can connect from MS SQL Server Manager then I can also connect from CCS. Plus MS SQL Server shows the server name too, so I don't have to know or remember it. For example on my local computer I see the server name as "MyComputerName\SQLEXPRESS", so I copy this server name into CCS.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.