
July 22nd, 2002, 06:10 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
sql server and database help
<i><b>Originally posted by : mark hamer (markhamer9@aol.com)</b></i><br />Hi,<br /><br />I am learning asp.net however do not understand how the sql database really works and more importantly how it is created. I am running a trial version of sql server 2000 and would like to know if sql databases need to be saved on this. EG<br /><br />strconn = "Driver={SQL Server};Description=sqldemo;SERVER=jh;UID=sa;PWD=; DATABASE=identityexample"<br />set conn = server.createobject("adodb.connection")<br />conn.open strconn<br /><br />Otherwise can sql databases be uploaded to a virtual server like .mdb databases.<br /><br />I know i have asked a few questions at the same time, but if any one could basically explain to me about creating and hosting sql databases I would really appreciate it.<br /><br />Alternatively if any one knows any good tutorials.<br />thanks<br />
|