Re: How to get ODBC working with MSDE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: news.microsoft.com (eric.phetteplace_at_mhd.state.ma.us)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 14:04:28 -0400

Hi Sascha,

Did you ever get this working? I am running into the same thing - osql
works fine, odbc doesn't work and I can't connect from remote machines.

Eric
"Sascha Bohnenkamp" <bohnenkamp@mevisbreastcare.de> wrote in message
news:ivgua0tv5mfo29ppoe2i1k5al25i5tr6m5@4ax.com...
> Hi,
>
> I am new to SQLServer and have the typical start-problems. (I already
> have experience with other databases like oracle etc.)
>
> I have installed MSDE but the Servermanager does not see it !?
> If I try to configure an ODBC-Data-Source for it .. it cannot connect.
> (no mater which acount I use)
>
> I can use osql and have already created a test-database with one
> little tabel in it ...
>
> Any idea what I have to do to make it work?
>
>
> thanks

Relevant Pages

  • Re: isql.exe vs isqlw.exe vs osql.exe
    ... > I believe OSQL uses ODBC. ... SET NOCOUNT ON is the first line in the script. ...
    (microsoft.public.sqlserver.tools)
  • Re: Will SQL Server Be Backward Compatible with ISQL and DB-Lib?
    ... ODBC was followed by OLEDB somewhere about mid-end-nighties. ... ISQL was replaced by OSQL 1998 and OSQL was replaced by SQLCMD 2005. ... DB-Lib and is replacing them with OSQL and ODBC. ...
    (microsoft.public.sqlserver.programming)
  • using vbs
    ... I have written some batch scripts using osql to run some sql ... What kind of connection option ... Is there a way of not using ODBC but direct connection (just like ...
    (comp.databases.ms-sqlserver)
  • Re: osql works with SQL Server 6.5 ???
    ... It would seem that osql should work with SQL Server ... ODBC application would work. ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.sqlserver.tools)