| Subject | FB and Server.CreateObject("ADODB.Connection") ASP |
|---|---|
| Author | Tanz Anthrox |
| Post date | 2004-01-27T13:06:40Z |
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)
Regards,
********************************************************************************************************************************
<html>
<head>
<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">
<title>Report</title>
</head>
<body>
<%
Session.Codepage = "1254"
set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=SQLOLEDB;Data Source=2xx.xxx.xxx.xxx;User ID=yyyyyyyyyyyyyyyy;Password=pppppp;Initial Catalog=ggggggggggg.com"
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) %>
<tr>
<td width="10%"><% =rs("Code") %></td>
<td width="20%"><% =rs("Name") %></td>
<td width="70%"><% =rs("Detail") %></td>
</tr>
<%
rs.movenext
Wend
%>
</table>
<%
else
%>
Codes are not available.
<%
end if
%>
</body>
</html>
[Non-text portions of this message have been removed]
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)
Regards,
********************************************************************************************************************************
<html>
<head>
<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">
<title>Report</title>
</head>
<body>
<%
Session.Codepage = "1254"
set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=SQLOLEDB;Data Source=2xx.xxx.xxx.xxx;User ID=yyyyyyyyyyyyyyyy;Password=pppppp;Initial Catalog=ggggggggggg.com"
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) %>
<tr>
<td width="10%"><% =rs("Code") %></td>
<td width="20%"><% =rs("Name") %></td>
<td width="70%"><% =rs("Detail") %></td>
</tr>
<%
rs.movenext
Wend
%>
</table>
<%
else
%>
Codes are not available.
<%
end if
%>
</body>
</html>
[Non-text portions of this message have been removed]