DSNs

[vanillapod]

Right so i've nearly got my site finished on my PC with personal web server and an access database. When i transfer over to the actual server that the site will run on how do i setup the DSN? Do i need just one on the server or do i put one on each PC that will access the site? I guess it will only be one on the server? Can i copy the dsn from my pc over?

Cheers
Gary

 

[bdmoore]

Gary,

You will only need to set up one DSN on the server. Re-create the DSN under System DSNs in the ODBC Control Panel, ensuring that the database you are using is on the same server or one networked to it. As the ASP script is run on the server and not the client you will not need to make any changes to the PCs that access your site.

While Access databases are ok for this situation, if you have a large amount of data or expect a lot of hits on your site I would recommend moving to SQL Server.

----

Ben
MIS / Web Developer
(HTML, ASP, IIS, VB, JScript, SQL)

 

[vanillapod]

Cheers ben, yeah i'm a bit concerned about using MS access but have no choice. Am only expecting around 5-10 users making requests at any time so hopefully it will be okay...

Cheers again

How much would it cost to upgrade to SQL Server is it really expensive?

 

[link9]

You can usually find legitimate good deals on software on Ebay -- just be sure to use billpoint, or some other escrow service. It's saved me more than once.

Additionally, there is a dbms package out there called MySQL that is free... haven't used it, but ppl seem to like it pretty well. Only problem is that you won't have all the bells and whistles of the Access interface (or Enterprise Manager for SQL Server)

 

[webspy]

i think the MSAcces is enough for ur site.we can store nearly 30,000 records in a table.

Ok,database is ur choice.

about dsn.
u told that u are using DSN thru ODBC32. My suggession is
use DSN less connection for the database connection.
like this

dim dsn

dsn= "DBQ=" & Server.MapPath("db/egreetings.mdb&quot &";Driver={Microsoft Access Driver (*.mdb)};"

set myconn=server.CreateObject("adodb.connection&quot
myconn.Open dsn

remaining things are same as like u did in DSN connection.

if u use the dsnless connection, u need not worry about the DSN setup in the server.

with regards
webspy