Sybase .ADT files

Printable View

May 17th, 2010, 03:35 PM
stricknyn

Sybase .ADT files

Hello all,

Has anyone ever had to load a .ADT (Advantage database) file into a SQL Database? I'm exploring any option I can (vb, ssis, etc.) since I haven't figured this out yet. I'm not sure how to connect to file (ADO.NET). I think if I can figure that out, I'll be ok.

Thanks,

Strick
May 18th, 2010, 03:07 AM
jmcilhinney

Re: Sybase .ADT files

You'll need to have an appropriate ODBC driver or OLE DB provider installed, which you can probably only get from Sybase. You can then use Odbc or OleDb or some third-party ADO.NET provider in VB.NET or SSIS.

http://connectionstrings.com/sybase-advantage
May 18th, 2010, 05:57 AM
Hack

Re: Sybase .ADT files

Moved To Database Development
May 18th, 2010, 07:30 AM
stricknyn

Re: Sybase .ADT files

Quote:

Originally Posted by jmcilhinney

You'll need to have an appropriate ODBC driver or OLE DB provider installed, which you can probably only get from Sybase. You can then use Odbc or OleDb or some third-party ADO.NET provider in VB.NET or SSIS.

http://connectionstrings.com/sybase-advantage

Hello, thanks for your response. I think this was where I am really confused. The connection strings here look like they are for connecting to a Advantage database where I need to connect to a file (.adt) file.

Thanks,

Strick
May 18th, 2010, 09:49 AM
jmcilhinney

Re: Sybase .ADT files

Is that actually possible? I have no idea whether it is or not but if it's anything like SQL Server you cannot just connect to a file without a server.
May 18th, 2010, 10:42 AM
stricknyn

Re: Sybase .ADT files

Hi,

Yep it's possible. I had a project a few years ago where I used to connect right to comma delimited text files.

For this project your advice was very helpful. I was able to download the Advantage.Data.Provider .net provider. Once I did that, it showed up in references.

I'm now playing around with the provider trying to get familiar with it.

Thanks,

Strick