Subject FB and Server.CreateObject("ADODB.Connection") ASP
Author Tanz Anthrox
Hi !

I don't know here is the right place to ask but,
Is it possible to connect Firebird with web interface? and run simple queries like small ASP snippet show below.
What is the connection string?

Can we use .NET provider for this purposes? (There is no information about this)




<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">



Session.Codepage = "1254"

set conn = Server.CreateObject("ADODB.Connection") "Provider=SQLOLEDB;Data;User ID=yyyyyyyyyyyyyyyy;Password=pppppp;Initial"

sql = "SELECT * FROM CODES WHERE Code < 100"
set rs = conn.execute (sql)

if not rs.EOF then

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<% While (Not rs.EOF) %>

<td width="10%"><% =rs("Code") %></td>
<td width="20%"><% =rs("Name") %></td>
<td width="70%"><% =rs("Detail") %></td>



Codes are not available.

end if



[Non-text portions of this message have been removed]