-
Here's my situation.... Our company network is Microsoft Office (I Love it) and our company database is Sybase. We've been using Access for our manufacturing data and with 30 - 40k records and a bunch of related Tables...... ...it's terribly slow. We need to get it into Sybase! I haven't programmed for 10 years (QB 7.0 is what I last used on DOS) but I just bought VB 6.0 Pro edition and I'm going to tackle this puppy! (I am familiar with ACCESS by the way)
Here's my QUESTION / PROBLEM.... Will I need or should I get 3rd party software in order to connect to the Sybase server? The reason I ask is that I tried once before using VB 4.0 and I just couldn't do it! I went through the datbase tutorial and I was very surprised when Karl even mentioned Sybase! Most advertisements for VB always mention Microsoft SQL server & Oracle......but they rarely say anything about Sybase. Most books concentrate on using VB with Microsoft SQL server or Oracle(Did Bill piss these guys off or something?) Please don't tell me I have to use Powerbuilder....I happen to like the Microsoft family of products!....so I really want to get this figured out!
A BIG THANK YOU in advance for many anticiapted replies and reassurance!
-
You don't have to use any other third party libraries. You can just use ADO to connect to Sybase database. Next example assumes that you have Sybase System 11 ODBC driver installed:
Code:
Dim cn As New ADODB.Connection
Dim strConn As String
strConn = "Driver={Sybase System 11};ServerName=MyServer;LogonID=MyLogon"
cn.Open strConn, , "MyPassword"
'Here do other stuff after you have connection opened.
That's it.
-
Get yourself a copy of Sybase SQL Server 11 Unleashed. It's very useful. I've been doing VB4/5/6 & VBA front-ends to Sybase for two good-sized companies almost exclusively for the last four years, if you have any "must know" questions, don't hesitate to email me, [email protected] (especially, if by chance, you're playing in Facets). Otherwise, like Serge said, you need only use the Sybase System 11 drivers. FWIW, much of what is written for VB-to-Oracle is identical for Sybase.
