dbTalk Databases Forums  

Bindvariables in from-clause connecting to sql server by ole db

comp.databases.gupta comp.databases.gupta


Discuss Bindvariables in from-clause connecting to sql server by ole db in the comp.databases.gupta forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tinkerbel75@hotmail.com
 
Posts: n/a

Default Bindvariables in from-clause connecting to sql server by ole db - 05-15-2005 , 04:34 AM






I have the following problem. I get an error on the prepare of this
statement.

SELECT OMS.sOmschrijving, TAAL.sTaal
FROM (TAAL LEFT OUTER JOIN OMS ON OMS.nTaalUN = TAAL.nUN AND
OMS.nParentUN = nParentUN)

When I use odbc it al works fine, but when I use ole db I get an error
on the variable in the from-clause. When I replace this variable by
it's value it also works fine.

Does anybody have any idea what I'm doing wrong?

Thanks


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.