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
|
|
|
 |