Menu
▾
▴
Re: [Firebird-odbc-devel] Beta v2.0.0128 - can only connect with SYSDBA when using embedded
|
From: Werner F. B. <wer...@fr...> - 2006-03-20 08:53:42
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Vladimir,<br>
<br>
Vladimir Tsvigun wrote:<br>
<blockquote cite="middvkb1i$j8n$1...@ne..." type="cite">
<pre wrap="">Hi Werner,
</pre>
<blockquote type="cite">
<pre wrap="">However when I try to connect on that same machine using the embedded
server (1.5) I can only connect to a database with SYSDBA other user
accounts are not accepted (MYUSERXYZ - which only has read only
priviledge).
</pre>
</blockquote>
<pre wrap=""><!---->
I am tested
Firebird-1.5.3.4870-0_RC3_embed_win32.zip
and not problem.
</pre>
</blockquote>
I am using version 1.5.0.4290 of the dll.<br>
<blockquote cite="middvkb1i$j8n$1...@ne..." type="cite">
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">I then tried it on a second machine which does NOT have
the server installed and I see that same problem.
To test the connection I already fail within the ODBC control panel.
</pre>
</blockquote>
<pre wrap=""><!---->
Please, step by step, how to repeat.
</pre>
</blockquote>
- Installed the ODBC soft using the windows installer and selecting
deployment install.<br>
- On Firebird ODBC Setup<br>
- selected database<br>
- selected client <br>
- entered database account "MYWINECBREAD" - it has only select
privileges<br>
- entered password<br>
- Character set = None<br>
- Read is clicked<br>
- Dialect 3<br>
<br>
Click on Test Connection, get error "Error open database "db name"
failed".<br>
<br>
If I just change the database account to "SYSDBA" and the password and
then click on Test Connection it works. If I set account to another
user which is defined and has same access as SYSDBA it does NOT work.<br>
<br>
Just for the heck I then tried to open the db via ODBC from OpenOffice
and that worked. Going back to the ODBC setup I still get the error.<br>
<br>
Hope this helps<br>
Werner<br>
<br>
P.S. This is on Windows 2000 Pro<br>
</body>
</html>
|
