http://www.connectionstrings.com/ <http://www.connectionstrings.com/> has ODBC, OLE and AseConnection connection strings for Sybase. Dan
________________________________ From: archimedes_2369 [mailto:[EMAIL PROTECTED] Sent: 07 February 2005 14:38 To: [email protected] Subject: [AspClassicAnyQuestionIsOk] ODBC Hi, I have to access a Sybase SQL Anywhere 5.0 (It is a server running Blackbaud if anyone is familiar with this application). Can anyone please tell me the connection string. For SQL Server I use something similar... I guess I just need to know what is the Provider for Sybase SQL Anywhere 5.0. Thanks a zillion Andrea Private Function ConnectToBack() SQL_USER = "" ' My UserID SQL_PASSWORD = "" ' My Pwd SQL_DATABASE = "" 'DB Name SQL_Server = "10.0.0.8" Dim strConnection As String Set cnn = New ADODB.Connection Set cnn = New ADODB.Connection With cnn .Provider = "SQLOLEDB" .ConnectionString = "User ID=" & SQL_USER & ";" _ & " Password=" & SQL_PASSWORD & ";" _ & "Data Source=" & SQL_Server & ";" _ & "Initial Catalog=" & SQL_DATABASE .Open End With blnConnected = True End Function ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
