|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 7th, 2004, 09:07 PM
|
|||
|
|||
Linked Server to FireBird DataBase
Hello, I am trying to create a Linked Server from MSSQL Server 2000 to FireBird as part of one of our classes practice. I downloaded the following version:
And I installed it. Then I downloaded the following ODBC: Version 1.2
Afterwards I tried to create a Linked Server to the employees database included inside the folder of "examples" Here I include the Provider String I used (I was desperate so I also changed the password from "masterkey" to "none"): DRIVER={Firebird/InterBase(r) driver};UID=SYSDBA;PWD=none;DBNAME=C:\Firebird\DataBases\TEST.GDB Could you please help me? I have been playing with the options of the Security Tab and I will always get the same error Message: Authentication Failed Thank you in advance!
|
|
#2
November 8th, 2004, 03:41 AM
|
||||
|
||||
|
It's very easy:
1.Set up and test a system ODBC datasource pointing to your firebird database (with IBPhoenix's odbc driver) 2. Add a linked server with the following properties (this is an example): 2.0 Choose Microsoft OLE DB provider for ODBC drivers 2.1 Linked server name: "Local Firebird" 2.2 Product name: "Local Firebird" 2.3 Data source: the name of your odbc datasource 2.4 Provider string: "{Firebird/Interbase(r) Driver}" 2.5 Location: "localhost" (I'm pretty shure that 2.2, 2.4 and maybe 2.5 can be ignored, but I have no time to test) Don't forget to set auth to connect with sysdba/masterkey or other appropriate Firebird user
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) Last edited by pabloj : November 8th, 2004 at 03:53 AM.
|
|
#5
November 9th, 2004, 08:10 AM
|
|||
|
|||
|
Ooops... Sorry, I forgot to attach the error image. I am not in my house right now so I can't upload it in this moment... I will attach it when I am in my house. Anyway, the error says "Authentication Error"
|
|
#6
November 9th, 2004, 08:19 AM
|
||||
|
||||
|
In my setup I'm using SQLServer's authentication (I'm user "sa") and I set it up to map Local Login "sa" to Remote User "sysdba" with password "masterkey".
Last edited by pabloj : November 9th, 2004 at 08:21 AM.
|
|
#7
November 9th, 2004, 11:41 AM
|
|||
|
|||
|
Thanks for the reply... Sadly I have already tried that too and it told me the same... I don't know which the problem is. I will take a screenshot of my new attempt here in university. What is strange is that I did the same with a gemini driver and it worked... Why? Shouldn't the given driver work like the one provided by Gemini?
|
|
#10
November 10th, 2004, 11:04 AM
|
|||
|
|||
|
Yes, I did. You can check so by opening the first two attachments... I show there the configuration of the Linked Server. I wonder if something is wrong with the driver because I can do this using the Gemini driver... (With the same properties... I just changed the provider connection) Maybe it is a problem with my Provider String? Gemini didn't work until I used the following format: Database=localhost:C:\FireBird\Test.gdb; SERVER=localhost In gemini I was missing the Server part of the connection... Could it be the same case in the driver given by IBPhoenix?
|
|
#11
November 10th, 2004, 11:15 AM
|
||||
|
||||
|
I really don't know how to help you, I got mine working fine with the steps I showed you.
What kind of auth do you have in SQLServer it's own or the integrated one?
|
|
#13
November 10th, 2004, 07:40 PM
|
|||
|
|||
|
Ok, I found it... Now I can tell why it didn't work. It had to do with the provider string as I suggested. I changed the string to: DRIVER={Firebird/InterBase(r) driver};UID=SYSDBA;PWD=none;DBNAME=localhost:C:\Firebird\DataBases\TEST.GDB and it worked! As you can see I just had to specify the Server (localhost) in order to get it working (But it shouldn't be that way, should it?) Thank you pabloj for your time. 
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Linked Server to FireBird DataBase |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
