CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 MS sql connection

Print topic Send  topic

Author Message
sara
Posted: 09/24/2002, 10:24 AM

hiii i have problem in the connection string in the common file with the ms sql server its working good in the local host but when i put it on the site the site is opend but nothing is retreived from the data base !!!

this is the site http://www.ksaguide.com

and this is the connection string


Dim strConn, strLogin, strPassword
' strConn = "Provider=SQLOLEDB.1;Initial Catalog=FINAL_PROJECT;Data Source=back1.atheer.net.sa"

strConn= "Provider=SQLOLEDB;Data Source=back1.atheer.net.sa; Initial Catalog=ksaguide;User Id=ksaguide;Password=****;Connect Timeout=15;Network Library=dbmssocn;"
'strConn= "Provider=SQLOLEDB;Data Source=back1.atheer.net.sa;Initial Catalog=FINAL_PROJECT;Connect Timeout=15;Network Library=dbmssocn;"


'strLogin = "ksaguide"
'strPassword = "*****"

Farooq
Posted: 09/24/2002, 9:43 PM

Do you know the exact path of database on server. Have you already uploaded any database on that server because some server have the special directory of databases on the server for security reasons. What is the error message?

Farooq
farooqsdnp@yahoo.com
*sara
Posted: 09/26/2002, 5:46 AM

will yes the company restored the data base but they gave me the IP and the FTP i gust wana make sure that what i wrote is correct
*sara
Posted: 09/26/2002, 5:48 AM

there is no error message when i open the site it just that when i make search it doesnt give me any result it seems that its not connected to the data base

   


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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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