ODBC/ASP/Server connection

[Wayne]

I'm a newbie and am having problems writing the script to connect to our SQL
Server using ASP. I know its possible but I can't do it. Could there be
complications with ODBC? Any examples would be appreciated.
Thanks

[kendel]

"Wayne" <writter@marketingproducts.com> wrote:
>
>I'm a newbie and am having problems writing the script to connect to our
SQL
>Server using ASP. I know its possible but I can't do it. Could there be
>complications with ODBC? Any examples would be appreciated.
>Thanks

Take a look at my code:

var SQLString;
var rs;
var SQLConn;

SQLConn = Server.createobject("ADODB.Connection");
SQLConn.open(Application("WebDSN"));

rs = Server.CreateObject("ADODB.RecordSet");
rs.CursorType=1;
rs.activeConnection=SQLConn;

SQLString = "Select * from TableName";

rs.source = SQLString;
rs.open();

hope this will help...

[Wayne]

"kendel" <datsg_2000@yahoo.com> wrote:
>
>"Wayne" <writter@marketingproducts.com> wrote:
>>
>>I'm a newbie and am having problems writing the script to connect to our
>SQL
>>Server using ASP. I know its possible but I can't do it. Could there
be
>>complications with ODBC? Any examples would be appreciated.
>>Thanks
>
>Take a look at my code:
>
>var SQLString;
>var rs;
>var SQLConn;
>
>SQLConn = Server.createobject("ADODB.Connection");
>SQLConn.open(Application("WebDSN"));
>
>rs = Server.CreateObject("ADODB.RecordSet");
>rs.CursorType=1;
>rs.activeConnection=SQLConn;
>
>SQLString = "Select * from TableName";
>
>rs.source = SQLString;
>rs.open();
>
>hope this will help...
>
Thanks.