Hagen Schl�mer wrote:
> Ich habe ein keines Problem mit einer ODBC-basierenden
> Abfrage eus meiner
> Applikation: Alles funzt prima, aber ich mu�, damit es
> funktioniert den
> kompletten Tabellnamen in den SQL-Statements angeben also
> z.b. Select * from
> "USER"."tblName". Da meine Applikationen urspr�nglich Access b.z.w den
> MS-SQL-Server benutzten, m��te ich alle Abfragen umbauen.
> Gibt es einen
> ODBC-Parameter, mit dem man den "Eigent�mer-Namen" fest
> einstellen kann?
1. this is a mailing list using the english language.
2. select * from tabname will work if you are the owner of that table
(or with some special systemviews)
3. If you will use tables of another user, you always will have to
specifiy the corresponding username, no matter if odbc or whatever.
4. There is not possiblity to say 'use always the user_name xyz'
except by connecting as xyz.
5. You are sure that you did not confuse the special register USER
returning the current user and a user called "USER" ?
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
