Microsoft ASP vs ChiliSoft!ASP

[DougP]

One site that uses Microsoft ASP this code works perfect to open a SQL Server database and table.
-----------------------------------------
<%
Set Conn = server.CreateObject(&quot;ADODB.Connection&quot
Conn.Open &quot;driver=SQL Server;server=mysite.com;uid=user;pwd=pass;database=MyDB;&quot;
Set RS = Conn.Execute(&quot;SELECT Count(*) AS Recs FROM [sysnames]&quot
%>
Records Found  <%=RS(&quot;Recs&quot%>
-----------------------------------------

Now on the ChiliSoft! site I get the following error:
---------------------------------------------
ADODB.Connection.1 error '80004005'

SQLState: 01S00
Native Error Code: 0
SQLState: 08001
Native Error Code: 0
[MERANT][ODBC SQL Server Driver]Insufficient information to connect to the data source
[MERANT][ODBC SQL Server Driver]Invalid connection string attribute

/asp/upln.asp, line 15
----------------------------

Line 15 is:
Conn.Open &quot;driver=SQL Server;s.....

I know I need a Global.ASA file but I don't know where to put it or what to put in it.

I just need some sort of database, Access or SQL or even a TEXT file.
I want to create a DEMO on this site.

Any Help would be greatly appreciated

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[palbano]

Doug,

Have you tried the Chili soft support forum?

http://www.chilisoft.com/support/default.asp

Good luck
-pete