|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Visual basic & firebird DB (in unix machine)
hi guys, one project in VisualBasic: i have this part of code which is workin' very fine on a local machine :
Dim cn As New ADODB.Connection Dim sConnStr As String sConnStr = "Provider=ZStyle IBOLE Provider;Password=masterkey;User ID=SYSDBA;SQL Dialect=3; Logging Level=0;Silent mode=True;Character Set=WIN1251;Data Source=" & App.Path & "\T20060428_Total.gdb" cn.ConnectionString = sConnStr cn.Open how can i connect with this db through the network if it's located on a unix machine? someone please help me. many thanks in advance. |
|
#2
|
||||
|
||||
|
Never ever used that driver, but network connections through Firebird ODBC driver work fine.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
Quote:
code sample would be nice. thanks |
|
#4
|
||||
|
||||
|
You can find code samples with the odbc driver, see the sticky thread for download link (or directly from here)
|
|
#5
|
|||
|
|||
|
thanks, so here is the code for who is interested:
Dim cn As New ADODB.Connection Private Sub Command1_Click() Dim sql As String Dim sConnStr As String sConnStr = "Provider=ZStyle IBOLE Provider;Password=masterkey;User ID=SYSDBA;SQL Dialect=3; Logging Level=0;Silent mode=True;Character Set=WIN1251;Server=192.168.0.78;Data Source =192.168.0.78:/DATABASE/TIME_DBS/T20060504_Total.gdb ;Uid=root;Pwd=saert2" cn.ConnectionString = sConnStr cn.Open |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Visual basic & firebird DB (in unix machine) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|