Hello,
I'm trying to import a .DBS file into SQL Server 2000 but I don't know which
Data Source to choose. The file is used by an application that has an 'SQL
Engine' but unfortunately, that is all I know!

Does anybody have any suggestions?

Thanks in advance
Brian.

Does this list help?

http://filext.com/alphalist.php?extstart=%5ED


http://www.liutilities.com/products/...ary/files/DBS/


Allan



"Lost and Confused" <lostandconfused (AT) nowhere (DOT) com> wrote

Hi Allan,
Thanks, it confirms that the .DBS file relates to 'SQLBase Server'
www.guptaworldwide.com

Their website is full of phrases like 'full compatibility' but I still don't
know how to import the data
Any more suggestions?

Thanks
Brian.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Gupta apparently has an ODBC driver. See the drivers section here:
http://www.guptaworldwide.com/Produc....aspx?ProdID=1

If your file is in its native format then you'll probably need to
install the SQLBase software in order to read it using ODBC. (I'm just
guessing and Googling for you. I have no personal experience of this
database).

--
David Portas
SQL Server MVP
--

Hi David,
Thanks for the link but it seems as though the ODBC driver is not included
in the older version we have.

I can query the data using 'SQL Talk' if I am physically in front of the
computer but I would really like to copy/replicate it to SQL 2000 so that I
can publish reports on an Extranet. Any more suggestions?

Thanks
Brian.

"David Portas" <REMOVE_BEFORE_REPLYING_dportas (AT) acm (DOT) org> wrote

There is a document available on the site that looks as through it might be
worth looking at-
"Guide to Connecting to SQLBase (html)"

There is also a driver pack, which according to the details includes the
OLE-DB and ODBC driver amongst others. Can you not download this and give it
a try?

The simple answer is that SQL Server including DTS does not ship with a
native SQLBase diver. The way to connect to thrid-party systems is an OLE-DB
or ODBC driver, so can you not obtain one from Gupta?

Get the driver, and install it the machine running DTS.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Lost and Confused" <lostandconfused (AT) nowhere (DOT) com> wrote

Hi Darren,
The driver is called 'sqlbaseodbcsetup.dll' but it will only work with
version 9 of SQLBase
I contacted the application vendors to see if I could upgrade from version
7.6.1 but they said it would not work with the application!

The frustrating thing about this is that the application vendors are
offering a service where we FTP our data and they then publish the data via
http using Webex. I tried to find out how they managed it but they are
reluctant to tell me...

Thanks
Brian.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Hi again,
I have managed to 'UNLOAD' a '.SQL' file using SQLTalk, which is 519mb in
size.

I tried to use DTS to import the text file but it came up with an error at
line number 984,689
I then opened it up in Notepad and copied a little bit of it into 'Query
Analyser' but found that I had to change things like 'DATE' to 'DATETIME'
etc.

Very frustrating

Thanks
Brian.

"Lost and Confused" <lostandconfused (AT) nowhere (DOT) com> wrote