Re: SQL Server with ASP for navision

From: Nuno Silva (silva_nunoN_at_SPAMhotmail.com)
Date: 03/11/04


Date: Thu, 11 Mar 2004 08:23:50 -0000

When you have a special char in a name of any object of SQL server you have
to use the name between square brackets like [cronus$customer]

"Liada" <anonymous@discussions.microsoft.com> wrote in message
news:D0A13DB1-A019-4D2D-AD2E-1B6B74E9C0E5@microsoft.com...
> I have problem of Navision within MS SQL.Problem is , I want select
customer table within ASP. But when I connecting the MSQL server, I take
error because Navision table name have '$' character.
>
> How to find good solutions? I try to C/ODBC but not working.
>



Relevant Pages

  • Reading data from Navision to SQL Server: Date issues
    ... SQL Server 2000 database via ODBC. ... This notation is the one required by C/ODBC Navision driver. ...
    (comp.databases.ms-sqlserver)
  • Re: Synchronizing database logins with Sql Server
    ... The Microsoft Business - Solutions Navision and the SQL Server ... login does not exist ont he Fourtest Server. ... added to the SQL Server first and then the database was restored. ...
    (microsoft.public.sqlserver.security)
  • Problems importing data with ODBC Navision Attain 3.6
    ... I have problems to import data from Navision Attain into SQL Server ... To import data we use DTS and for the connection to the Navision db we ... get an DTS import/export error: ...
    (microsoft.public.sqlserver.odbc)
  • SQL linked server with ODBC
    ... I am having trouble extracting data from a Navision ... database via an sql linked server. ... I am using sql server 2000. ... I created a linked server using OLE DB provider ...
    (microsoft.public.sqlserver.odbc)
  • ODBC linked server
    ... I am having trouble extracting data from a Navision ... database via an sql linked server. ... I am using sql server 2000. ... I created a linked server using OLE DB provider ...
    (microsoft.public.data.oledb)