Anyway, the login is failing because the app is using the MS SQL Server provider (System.Data.SqlClient) and not the Firebird provider. Check that the you are specifying the Firebird provider in your SqlMap.config file and that the provider is "enabled" in your providers.config file (otherwise, the default provider that will be used is MSSQL SqlClient).
You'll still have to make the code change I sent earlier to get past the Firebird connection Clone() exception with the connection string.
Hope this helps!
Roberto
On 5/18/05, Sunil Sreedharan <[EMAIL PROTECTED]> wrote:
Hi,
Posted below is the complete Error Trace.
Server Error in '/WebSite1' Application.
--------------------------------------------------------------------------------
Login failed for user 'SYSDBA'.
Description: An unhandled exception occurred during
the execution of the current web request. Please
review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException:
Login failed for user 'SYSDBA'.
Source Error:
Line 27: 'myReader.Close()
Line 28:
Line 29: Dim list As IList =
iMapper.Instance.QueryForList ("GetCustomer", Nothing)
Line 30: Dim i As Integer
Line 31: For i = 0 To list.Count - 1
Source File: C:\WebSites\WebSite1\FBTest.aspx.vb
Line: 29
Stack Trace:
[SqlException (0x80131904): Login failed for user
'SYSDBA'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object
owningObject) +317
System.Data.ProviderBase.DbConnectionFactory.GetConnection (DbConnectionBase
owningConnection) +90
System.Data.ProviderBase.DbConnectionClosed.Open(DbConnectionBase
outerConnection) +189
System.Data.ProviderBase.DbConnectionBase.Open()
+62
System.Data.SqlClient.SqlConnection.Open () +168
IBatisNet.DataMapper.SqlMapSession.OpenConnection()
+76
[DataMapperException: Unable to open connection.]
IBatisNet.DataMapper.SqlMapSession.OpenConnection()
+131
IBatisNet.DataMapper.SqlMapper.QueryForList (String
statementName, Object parameterObject) +103
FBTest_aspx.Page_Load(Object sender, EventArgs e)
in C:\WebSites\WebSite1\FBTest.aspx.vb:29
System.Web.UI.Control.OnLoad(EventArgs e) +87
System.Web.UI.Control.LoadRecursive () +55
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint) +2836
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework
Version:2.0.40607.42; ASP.NET Version:2.0.40607.42
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
