connection problem.

From: Arvid Mestdagh (am@cipal.be)
Date: 09/24/02 

From: "Arvid Mestdagh" <am@cipal.be>
Date: Tue, 24 Sep 2002 03:56:51 -0700

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

Relevant Pages

  • Re: connection problem.
    ... > b)On SQL server the owner of all the tables is CIPALII. ... > 3)Using standard dbo user as owner in sql server. ... > alias which uses the CIPALII every time for connections to ...
    (microsoft.public.sqlserver.security)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: [PHP] ODBC and long text fields
    ... We've a PHP app that uses ODBC to talk to a MS SQL server. ... The internal code for a query is ...
    (php.general)