Connecting to SQL 2000 Database - New at this

Tee88 · October 1st, 2004, 11:33 AM

Conn.Open "DSN=HRdbase;UID=;pwd=;"

I checked the connection and it tests successfully.

happygv · October 1st, 2004, 11:38 AM

Check if you are missing the UID and PWD values there.
I would suggest you not to use DSN connection, as that is not among the recent ways of connecting to databases and seems to be slower approach as suggested in many of the other posts. Moving out in a hurry...

Cheers!

_________________________
- Vijay G
Strive for Perfection

Tee88 · October 1st, 2004, 11:43 AM

Where can I find the new ways to connect. I just finished a training class and that is how they taught us to connect. Go figure it wouldn't be the best way.

Thanks for all your help!

dalewright22 · October 1st, 2004, 12:11 PM

TEE88 there is plenty of websites out there explaining connection strings etc. as happygv says, stay away fro using DSN connections, as these really aint the standard why of connecting to data stores. I suggest using a DSN-less connection, do a search on google. Also think about purchasing Wrox ASP beg book or the database one.. U will find loads of useful information and it will also give u a good basis of how to start programming in ASP

DJWright

happygv · October 2nd, 2004, 04:23 AM

Hi Tee,

Well, Though there are a lot of such discussions over the performance on using the connection string, I would suggest you, stick with OLEDB standard connection string, as it is the native provider.

OLEDB - commonly used standard connection string.
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

Then your code would be ...

Code:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=sqloledb;Data Source=YOUR_SERVERNAME;Initial Catalog=YOUR_DATABASENAME;User Id=YOUR_SQL_USERNAME;Password=YOUR_PASSWORD;"
Conn.Open
'Now the connection to your sql server is made to executing 
the sql statement that you construct at the later part of this code.

Replace all the entries in the connection string posted above, that are prefixed with YOUR_
with the values that apply to your sql server.

Also take a look at this article, that would shed some light on Connection string.

DSN, DSN-Less or OLEDB?

What's in an ADO Connection String?

Miscellaneous tips for improving ASP performance and robustness

Quote from another site.

Quote:

quote:Why to use DSN Connections ?
* Provides easy to remember data source names.
* When there are lots of data sources to think of and you want a central repository to hold the collection
of data sources without having to worry about the actual site and configuration of the data sources.

Why to use DSN less Connections ?
* When you can't register DSNs yourself e.g. when you are running a virtual hosting account on other's server.
Stop emailing system administrator for Creating/Editing DSNs on the hosting server, but can connect to your databases directly.
* Provides faster database access because it uses native OLE DB providers, while DSN connections make use of ODBC drivers.

Hope this helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection