Re: connection problem.
From: jimmers (jimmers@yandex.ru)
Date: 09/24/02
- Next message: Peter van der Veen: "How to change the owner of a table in SQL 65?"
- Previous message: jimmers: "Re: SQL Server Authentication hacking"
- In reply to: Arvid Mestdagh: "connection problem."
- Next in thread: Bill Hollinshead: "Re: connection problem."
- Reply: Bill Hollinshead: "Re: connection problem."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "jimmers" <jimmers@yandex.ru> Date: Tue, 24 Sep 2002 15:36:57 +0400
No. Best way is to fully qualify names of objects.
Cheers
jimmers
"Arvid Mestdagh" <am@cipal.be> wrote in message
news:726d01c263b9$16899490$35ef2ecf@TKMSFTNGXA11...
> Hi,
>
> I have a following situation :
> a)ODBC setting going to sql2000 server on windows
> authentification. Connection test for odbc OK.
> b)On SQL server the owner of all the tables is CIPALII.
> c)When using a VB program I goth the error that table X
> not exists.
>
> Solution include :
> 1)Using CIPALII. before every call made in VB
> 2)Using SQL server authentification for the odbc settings
> and using user CIPALII
> 3)Using standard dbo user as owner in sql server.
>
> But Is there another posibility in SQl server like an
> alias which uses the CIPALII every time for connections to
> taht database? Meaning I could leave everything as is and
> create that alias in sql server?
>
> thank you
> Arvid
- Next message: Peter van der Veen: "How to change the owner of a table in SQL 65?"
- Previous message: jimmers: "Re: SQL Server Authentication hacking"
- In reply to: Arvid Mestdagh: "connection problem."
- Next in thread: Bill Hollinshead: "Re: connection problem."
- Reply: Bill Hollinshead: "Re: connection problem."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
