sp_addlinkedserver to Tetra via Transoft odbc

jakub wilk

unread,

Apr 7, 2003, 10:07:05 AM4/7/03

to

I've got a problem with linking using Transoft ODBC driver
to SQL Server 2000. If you can give me some suggestion
once again please...

1. I install transoft odbc, create system DNS, i called
dsn optimum
2. i'm tring to create linked server using:
EXEC sp_addlinkedserver nazwa_linka
@server = 'Microsoft OLE DB Provider for ODBC',
@srvproduct = '',
@provider = 'MSDASQL',
@datasrc = 'optimum'
GO

- if I try to list tables it blocks sql server

------------------------------------------------
EXEC sp_addlinkedserver nazwa_linka
@server = 'Microsoft OLE DB Provider for ODBC',
@srvproduct = '',
@provider = 'MSDASQL',
@provstr = 'DSN=optimum;UID=login;PWD=password;'
GO

- i get error:
Error 7399: OLE DB provider 'MSDASQL' reported error. The
provider did not give any information about error.

Thanks in advance...

Jakub Wilk
enovatio sp. z o.o.
mailto:jakub...@enovatio.com
tel. +48 (22) 8701358
tel. kom. +48 (606) 647 367

Jakub Wilk

unread,

Apr 8, 2003, 6:00:50 AM4/8/03

to

Hi,
I were try to check conformance of odbc but the error occurs.
Description:

The application, , generated an application error The error occurred on
04/08/2003 @ 11:52:39.734 The exception generated was c0000005 at
address 00000000 (<nosymbols>)

Thanks,
jakub

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jakub Wilk

unread,

Apr 8, 2003, 6:21:16 AM4/8/03

to

When I try to run Select statement from Query Analyzer for linked server
I receive error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give
any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: The provider did not give any information about
the error.].

This start happend after instalation of Service Pack 3 for SQL Server.

Maybe I should install some hot fixes to start linked server with
transoft odbc,

Thanks in advance,

Bill Cheng [MSFT]

unread,

Apr 8, 2003, 4:10:50 AM4/8/03

to

Hi Jakub,

From your post, the problem occurs when you use "sp_addlinkedserver" to add
the linked server to a Transoft DSN. It seems that the two TSQL statements
both failed.

Since the problem involves a third party ODBC driver Microsoft does not
directly support, I suggesy that you contact Transoft.

1. Try to verify the conformance level of the ODBC driver.

2. The correct syntax to add a linked server to a Transoft DSN.

Q249043 INFO: Requirements for Developing ODBC Drivers for Use with MSDASQL
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q249043

You may also contact Microsoft Product Support Services at
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS. However,
I think we also need to involve Transoft.

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------
| Content-Class: urn:content-classes:message
| From: "jakub wilk" <jakub...@enovatio.com>
| Sender: "jakub wilk" <jakub...@enovatio.com>
| Subject: sp_addlinkedserver to Tetra via Transoft odbc
| Date: Mon, 7 Apr 2003 07:07:05 -0700
| Lines: 36
| Message-ID: <02fe01c2fd0e$f7fbd0c0$a001...@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcL9Dvf7MQNOD6VuQJyYiHwHdC/Eog==
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| Path: cpmsftngxa08.phx.gbl!cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa08.phx.gbl microsoft.public.sqlserver.odbc:37809
| X-Tomcat-NG: microsoft.public.sqlserver.odbc

Bill Cheng [MSFT]

unread,

Apr 9, 2003, 4:12:26 AM4/9/03

to

Hi Jakub,

Since this issue involves a third-party product, I suggest that you contact
Transoft to check if the ODBC driver is comformant and the correct syntax
to add linked server. You may also contact Microsoft PSS. We need to
involve the third party for further checking.

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------

| From: Jakub Wilk <jakub...@enovatio.com>
| References: <uHjD9Wb$CHA....@TK2MSFTNGP12.phx.gbl>
| X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
| Subject: RE: sp_addlinkedserver to Tetra via Transoft odbc
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| Content-Transfer-Encoding: 7bit
| Message-ID: <u3c6Xib$CHA....@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| Date: Tue, 08 Apr 2003 03:21:16 -0700
| NNTP-Posting-Host: actionjackson37.dsl.frii.net 216.17.146.37
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.odbc:38384
| X-Tomcat-NG: microsoft.public.sqlserver.odbc

Dave Hart

unread,

Apr 9, 2003, 9:41:40 AM4/9/03

to

Transoft ODBC... ugh, I've had experience with this and their support is a
joke.

What version of tsodbc32.dll and tsods32.dll do you have?

Cheers,
Dave

"jakub wilk" <jakub...@enovatio.com> wrote in message
news:02fe01c2fd0e$f7fbd0c0$a001...@phx.gbl...

Jakub Wilk

unread,

Apr 9, 2003, 10:33:02 AM4/9/03

to

I also 've got some experience, not only with Transoft - they are not
bad but ...

My versions:
tsodbc32.dll - 3.10.1.101
tsods32.dll - 3.10.0.0

On AIX server i've got Transoft v. 3.10.0332,

Thanks,

Bill Cheng [MSFT]

unread,

Apr 13, 2003, 10:04:20 AM4/13/03

to

Hi Jakub,

I am afraid that Microsoft does not support any third-party product. This
issue involves a third-party ODBC driver which we are not familiar with.
You would contact the third-party vendor for this problem.

I think you can check with other Microsoft-provided ODBC driver to test if
there is any problem (e.g. Microsoft Excel driver). If there is no problem,
it indicates that the problem is due to Transoft ODBC driver.

For the pricing of Microsoft Product Support Services, please check the
following link.
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------

| Subject: RE: sp_addlinkedserver to Tetra via Transoft odbc

| X-Tomcat-NG: microsoft.public.sqlserver.odbc
| Message-ID: <rFkEE$m$CHA....@cpmsftngxa06.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| Lines: 50
| NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182
| Path: cpmsftngxa08.phx.gbl!cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa08.phx.gbl microsoft.public.sqlserver.odbc:37826

Tony

unread,

Jun 27, 2003, 7:12:45 AM6/27/03

to

1) SQL Server connection to U/SQL via Linked Servers.

In order to use Linked Servers in SQL Server you will need
to have the latest revisions of the U/SQL software
installed on both Client and Server (limited support for
Linked Servers was first introduced in the tsodbc32.dll
3.10.0307 and Server engine v3.10.0332) . In addition you
will need to enable the FixedLengthCharType=Y directive in
the usqlsd.ini file. For example:

[books.udd]

Dictionary=../example/books.udd

Directory=../example

FixedLengthCharType=Y

A linked server connection to USQL can either be created

a) manually in the SQL Server Enterprise Manager

(select Security - Linked Server - New Linked Server -
OLE DB for ODBC and then enter the DSN name in the DSN
box. All other entries are not required.)

or

b) executing a system stored procedure (in the Query
Analyser) using:

EXEC sp_addlinkedserver @server='TRANSOFT'

,@datasrc='books.udd'

,@provider='MSDASQL'

,@srvproduct='ANY'

To interrogate your UDD via a linked server use the
following syntax:

select * from OpenQuery(<linked_server_name>,"Select *
from <table>")

2) Required Licensing to access U/SQL via a Linked Server

If you install the U/SQL Client on a Server based Windows
Operating System (Terminal Server, NT Server, 2000 Server)
OR if you use a service based application (SQL Server,
Crystal Web Reports etc) to access the U\SQL Client layer
then you will need to have a specific type of license
(Transoft calls this a Gateway license - this is
identifiable by a P2 in the license code string ) .