Hello Guyz!!!

I`ve got the following lines of code...

<%
Dim oRSbg, pos, wh
dsnname= "anthem"
Set oRSbg=server.createobject("ADODB.recordset")
pos = "shadow"

sqlbg = "Select * from background WHERE position='" & pos & "' ORDER BY id DESC;"
oRSbg.open sqlbg, "DSN=anthem"
%>

What I want to do is to pass the variable of "dsnname" to the line where I open the DSN ("DSN=anthem"). SO... how do I have to do that?
Any ideas???

Thank you in advance!

       Vagelis!

There are two ways to do it:

1.

dsnname = "DSN=anthem"
oRSbg.open sqlbg, dsnname

IMO, this is the easiest way, as it allows you to change the DSN to an OleDb connection later.

2.
oRSbg.open sqlbg, "DSN=" & dsnname

This way you hard code DSN= and use the variable dsnname for the actual DSN name.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you for your reply!

I guess that I`m not going to use the DSN connection though... I think that I`ll use a DSN-less connection. What`s your opinion on that? I think that it`s a bit faster.

Yeah, OledDB is faster and more reliable.
But what's more important: it's easier to manage. When you need to copy code from one server to another, all you need to do is copy the file. There is no need to access the server and use the ODBC panel to set up a DNS....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.