To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=45306
Issue #:|45306
Summary:|User not found: SA with second connection
Component:|Database access
Version:|680m84
Platform:|All
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|msc
Reported by:|pitonyak
------- Additional comments from [EMAIL PROTECTED] Thu Mar 17 07:05:12 -0800
2005 -------
I created a database called Time1.odb and then I ran the very simple macro shown
below. Notice that all I do is create a connection. The first time the macro
runs, everything is fine. The second time, I receive the error "User not found:
SA". If I inspect the connection Meta-data, the user is SA. I will attach a
document that indicates this. If I exit OOo and restart, then I can run the
macro again with no problem.
Sub Main
LookAtIt("file:///c:/Time1.odb")
End Sub
Sub LookAtIt(sDBURL$)
Dim oCon
Dim oBaseContext 'Global database context service.
Dim oDataBase 'Database obtained from the database context.
oBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oDataBase = oBaseContext.getByName(sDBURL)
oCon = oDataBase.getConnection("", "")
oCon.close()
End Sub
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
