sql server 2005 with postgresql as database

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql server 2005 with postgresql as database

Author

Topic

sree.kat
Starting Member

1 Post

Posted - 2009-02-20 : 01:20:09

i want to develop the cascading prompts in sql server2005 and my database is postgresql.

when am defining the query prompt, it doesn't allow me to define.

the code is

SELECT org_name, wt_id
FROM dimension_organization
where
wt_id=@wt
when i run the above query,am getting the error saying that 'wt'doesnot exists.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-02-23 : 04:25:13

Are you linking to your postgresql from Linked servers?

Jack Vamvas
--------------------
http://www.ITjobfeed.com

NeilG
Aged Yak Warrior

530 Posts

Posted - 2009-02-23 : 04:30:02

are you declaring the @wt first i.e. declare @wt varchar(30) for example

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources