MS SQL connection

[Atse]

Hi,

How can I make an MS SQL connection other than DSN? Thanks

Atse

[Aaron Bertrand [MVP]]

www.aspfaq.com/2126

"Atse" <du******@yahoo.com> wrote in message
news:oX*******************@news04.bloor.is.net.cab le.rogers.com...

Hi,

How can I make an MS SQL connection other than DSN? Thanks

Atse

[Atse]

By the way, how can I do if I don't want to write those lines on every pages
but write once somewhere and effect all pages, like making a global
connection? Can I?
Thanks again.

"Atse" <du******@yahoo.com> wrote in message
news:oX*******************@news04.bloor.is.net.cab le.rogers.com...

Hi,

How can I make an MS SQL connection other than DSN? Thanks

Atse

[Aaron Bertrand [MVP]]

No, you shouldn't do that, but you could use an #include file (or
global.asa) that has the connection string defined, then wherever you need
it you just say

set conn = server.createobject("ADODB.Connection")
conn.open connectionString ' or session("connectionString")

--
Aaron Bertrand, SQL Server MVP
http://www.aspfaq.com/

Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.
"Atse" <du******@yahoo.com> wrote in message
news:sg*******************@news04.bloor.is.net.cab le.rogers.com...

By the way, how can I do if I don't want to write those lines on every pages but write once somewhere and effect all pages, like making a global
connection? Can I?
Thanks again.

"Atse" <du******@yahoo.com> wrote in message
news:oX*******************@news04.bloor.is.net.cab le.rogers.com...

Hi,

How can I make an MS SQL connection other than DSN? Thanks

Atse

[Aaron Bertrand [MVP]]

> You mean I can do that like below?

<%
' this is in the page global.asa
cst = "Provider=SQLOLEDB;Server=<ip address>;database=<dbname>;"
cst = cst & "network=DBMSSOCN;uid=<uid>;pwd=<pwd>"
set conn = Server.CreateObject("ADODB.Connection")
This last line should *NOT* be in global.asa
<!--#include file=global.asa>

No, you don't #include global.asa. If you just want to #include a file,
name it something else, like connection.asp ...