Sybase .ADT files

[stricknyn]

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

[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

[Hack]

Moved To Database Development

[stricknyn]

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

[jmcilhinney]

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.

[stricknyn]

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