Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2008-03-31 : 04:05:00
|
| I am creating a linked sever from Informix server to SQL server 2005.And it is giving me the error of database not found or no system permission error. While my DSN is working find and test connection successed what could be the reason ?can any body help. below is the errorCannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "LIBRARY".OLE DB provider "Ifxoledbc" for linked server "LIBRARY" returned message "EIX000: (-329) Database not found or no system permission.". (Microsoft SQL Server, Error: 7303) |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-31 : 05:41:31
|
| How are you connecting with the linked server? Does it try to impersonate sa? If so, then you will need to grant the SQL Service account rights to the Informix database. If this is the case, then your DSN will work because your login has permissions to the database. |
 |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-03-31 : 06:28:57
|
| I am connecting the link server with DSN using the driver "IBM Informix ODBC Driver" which is in the Informix Client SDK 3.0. Test connection is successed. But when i try to create a link server it creates an error. I am stating here the info which i am using to create an error,i tried sa with imporsonating,with our withour security context,tried remote login it didnt work at all. I am using the win 2003 server with SQL 2005 installed.Provider:IBM informix OLEDB providerProduct Name: IfxoledbcDatasource:MYDSNProvider string:uid=myuid;pwd=mypwdAny help would be appriciated |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-31 : 07:08:05
|
| Did you have a look at the last post on your other thread?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98697 |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-03-31 : 07:18:57
|
| I have read the post you are mentioned RICK but actually i dont own the database and server is remote to me .. i just have a host name and ip address and the uid and pwd to connect. and this is all i am using to connect .. how can i try to create a table /row/ column ??? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 22:40:01
|
| You have to map sql user to informix user in linked server properties -> security. |
|
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2008-04-01 : 00:38:55
|
| i also map the sql user SA to informix user that i have mentioned in my provider string but to no use :( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-01 : 23:30:23
|
| Did you logon sql with sa for testing? |
|
|
|
|
|
|
EIX000: (-329) Database not found or no system per