Hi, I'm pretty novice in asp.net programming and I have to write a small
aspx page (using vbscript) to connect to a Firebird database. I've installed
DDEX and everything seems to be ok. Since the server I'm working on has
Visual Studio 2005 I've installed all fb components but I can't use them
(the icons in the toolbox are disabled). On the other hand, I've tried to
set up a new data connection using Firebird provider and it works.
I put this code in my page:
Code: Select all
<%@ Language="VBScript" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.data" %>
<%@ Import Namespace="FirebirdSql.Data.Firebird" %>
<script Language="VB" runat="server">
sub Page_Load(obj as object, e as eventargs)
dim conn
conn = New Firebird.fbConnection()
conn.ConnectionString =
"Database=c:\myDB.fdb;user=sysdba;password=masterkey;Server=xxx;Connection
timeout=20"
conn.Open()
Dim trans As Firebird.FbTransaction = conn.BeginTransaction
Dim cmd As New Firebird.FbCommand()
Dim dr As Firebird.FbDataReader
cmd.Connection = conn
cmd.Transaction = trans
cmd.CommandText = "Select * from xyz('" &
Request.QueryString.Item("aaaaa") & "')"
'
Try
dr = cmd.ExecuteReader
If dr.Read Then
lblNaam.Text = dr.GetString(0)
lblCode.Text = dr.GetString(1)
lblDatum.Text = dr.GetDateTime(2).ToShortDateString
lblToegekend.Text = dr.GetInt32(3).ToString
lblNT.Text = dr.GetInt32(4).ToString
lblAfgewerkt.Text = dr.GetInt32(5).ToString
lblOnverwisselbaar.Text = dr.GetInt32(6).ToString
End If'
'
Catch
trans.Rollback()
Finally
dr.Close()
CloseConn()
End Try
</Script>
<html>
I got this error:
Compiler Error Message: BC30002: Type 'Firebird.fbConnection' is not
defined.
Source Error:
Line 10:
Line 11: dim conn
[color=#FF0000] Line 12: conn = New Firebird.fbConnection()[/color]
Line 13:
Line 14: conn.ConnectionString =
("Database=c:\myDB.fdb;user=sysdba;password=masterkey;Server=xxx;Connect\
ion timeout=20"
Source File: c:\inetpub\wwwroot\firebird2.aspx Line: 12
Can anybody tell me what's wrong ?
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
