need help with database please

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

need help with database please

Author

Topic

alidad
Starting Member

3 Posts

Posted - 2008-08-28 : 15:22:53

Hi, i have shopping site project in ASP that someone did for me, i downloaded all of those files from server and installed on my computer. my next step is to change the database name to make connection.

I hardly can't remember what to change becuase is been while that i have not use asp database that why I can't figure out what to change.

please see copy of source code.

i use ms sql server 2005 and my mysql server name is AlidadMOS, i'm not sure where to look for user name and password from MS SQL Server 2005, please see copy of this code and see what do i need to change or remove and where do i look for user name nad password from MS sql 2005!

please help thanks.

Dim dbc
Dim strConn
Dim strpath
Dim conn

session.timeout=60   ''''' in minutes
sub openConn()
	strConn ="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Andy;PWD"3251"=;Initial Catalog=Alidad_shopmepal;"
	set dbc = Server.CreateObject("ADODB.Connection")
	dbc.ConnectionTimeout=60	
	dbc.open strConn
end sub

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-02 : 05:43:06

As suggested on the other site where you also put your query,
visit www.connectionstrings.com

for an updated reference how to construct a connectionstring.

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources