UNIConnection and problems with remote connection

jacek878 · Post by **jacek878** » Thu 11 Dec 2008 20:40

Hello Guys,
I have some sort of problem:
- while making remote connection using ADOConnection I don`t have any problems to open database
- if I use UNIConnection i use the same data and it shows connection error
I have no idea what is wrong
BR
Jacek

eduardosic · Post by **eduardosic** » Thu 11 Dec 2008 21:24

jacek878 wrote:Hello Guys,
I have some sort of problem:
- while making remote connection using ADOConnection I don`t have any problems to open database
- if I use UNIConnection i use the same data and it shows connection error
I have no idea what is wrong
BR
Jacek

You must inform more details on the problem

inform:
error message
Delphi Version
Unidac Version
database used and version

i use remote connection with mysql and no have problem.

jacek878 · Post by **jacek878** » Thu 11 Dec 2008 21:42

Delphi version 2007 Professional
UNIDac version 1.20.0.13
database: MSSQL2005 Express
TCP Error: Cannot establish connection with server or host didn`t resond in appropriate time

Dimon · Post by **Dimon** » Fri 12 Dec 2008 15:12

Please make sure that you set the Server property correctly. Also try to connect with the OLEBDProvider option set to prSQL.

MSCH · Post by **MSCH** » Mon 15 Dec 2008 18:27

i haved the same problem;
check if your installation is provided all IP-Addresses. (see SQL Server Configuration Manager).
cheers
Msch

jacek878 · Post by **jacek878** » Wed 17 Jun 2009 21:16

Hi Guys,
I still have a problem with remote connection using UniDAC and MSSQL.
I have tried many things:
1. OLEBDProvider set to prSQL, Native and Compact ( strange that if i set up OLEBDProvider to Compact i can connect but cannot select any data from database )
2. I`ve checked the configuration of SQL Server and it`s provided with all IP-Addresses.
3. Once again i can connect by ADOConnection and ODBC driver
4. If i use UniDAC 2.70.0.8 i receive error msg:
[DBNETLIB][ConnectionOpen(Connect()).]Cannot establish connection with server or host didn`t resond in appropriate time

0834A637]{msprovider105.bpl} Oledbaccessuni.TOLEDBConnection.OLEDBError + $49B
[08349EC2]{msprovider105.bpl} Oledbaccessuni.TOLEDBConnection.Check + $1A
[0834BE70]{msprovider105.bpl} Oledbaccessuni.TOLEDBConnection.Connect + $318
[2000846E]{rtl100.bpl } System.@WStrAsg (Line 14090, "sys\system.pas" + 10) + $0
[084A5EED]{dac105.bpl } Dbaccess.TCustomDAConnection.DoConnect + $C1
[0863BF9B]{unidac105.bpl} Uni.TUniConnection.DoConnect + $2F
[084A6203]{dac105.bpl } Dbaccess.TCustomDAConnection.PerformConnect + $37
[084A81A7]{dac105.bpl } Dbaccess.TCustomDAConnection.SetConnected + $2AF
[2002AE7E]{rtl100.bpl } TypInfo.SetOrdProp (Line 1316, "common\TypInfo.pas" + 27) + $0
[20D29FD6]{designide100.bpl} DesignEditors.TPropertyEditor.SetOrdValue (Line 841, "DesignEditors.pas" + 2) + $E
[20D2B073]{designide100.bpl} DesignEditors.TEnumProperty.SetValue (Line 1401, "DesignEditors.pas" + 5) + $4
[20D29C8D]{designide100.bpl} DesignEditors.TPropertyEditor.Edit (Line 671, "DesignEditors.pas" + 11) + $14
[20AB55C6]{coreide100.bpl} PropInsp.TPropertyInspector.PropListEditDblClick (Line 855, "PropInsp.pas" + 20) + $5
[20E0ED7D]{vclide100.bpl} IDEInspListBox.TInspListBox.DoEditDblClick (Line 967, "ideinsplistbox.pas" + 2) + $A
[20E10602]{vclide100.bpl} IDEInspListBox.TInspListBox.EditDblClick (Line 1538, "ideinsplistbox.pas" + 0) + $2
[2013CA49]{vcl100.bpl } Controls.TControl.DblClick (Line 5234, "Controls.pas" + 1) + $14
[2013CBAC]{vcl100.bpl } Controls.TControl.WMLButtonDblClk (Line 5275, "Controls.pas" + 4) + $C
[2013C527]{vcl100.bpl } Controls.TControl.WndProc (Line 5146, "Controls.pas" + 83) + $6
[201406A7]{vcl100.bpl } Controls.TWinControl.WndProc (Line 7304, "Controls.pas" + 111) + $6
[20D1972A]{designide100.bpl} DeskUtil.SetFocusHook (Line 435, "DeskUtil.pas" + 4) + $C
[2003203C]{rtl100.bpl } Classes.TThreadList.UnlockList (Line 3359, "common\Classes.pas" + 0) + $4
[200EBAA8]{vcl100.bpl } Graphics.FreeMemoryContexts (Line 5060, "Graphics.pas" + 12) + $5
[2013FDD0]{vcl100.bpl } Controls.TWinControl.MainWndProc (Line 7073, "Controls.pas" + 3) + $6
[2013FDE5]{vcl100.bpl } Controls.TWinControl.MainWndProc (Line 7076, "Controls.pas" + 6) + $0
[20040E4C]{rtl100.bpl } Classes.StdWndProc (Line 11583, "common\Classes.pas" +

+ $0
[20140158]{vcl100.bpl } Controls.TWinControl.IsControlMouseMsg (Line 7176, "Controls.pas" + 9) + $25
[201406A7]{vcl100.bpl } Controls.TWinControl.WndProc (Line 7304, "Controls.pas" + 111) + $6
[20E0DF4B]{vclide100.bpl} IDEInspListBox.TPropInspEdit.WndProc (Line 430, "ideinsplistbox.pas" + 7) + $4
[2013FDD0]{vcl100.bpl } Controls.TWinControl.MainWndProc (Line 7073, "Controls.pas" + 3) + $6
[20040E4C]{rtl100.bpl } Classes.StdWndProc (Line 11583, "common\Classes.pas" +

+ $0
[20137642]{vcl100.bpl } Controls.FindControl (Line 2104, "Controls.pas" + 6) + $9
[201625E8]{vcl100.bpl } Forms.TApplication.ProcessMessage (Line 8103, "Forms.pas" + 21) + $1
[2016262A]{vcl100.bpl } Forms.TApplication.HandleMessage (Line 8124, "Forms.pas" + 1) + $4
[2016291F]{vcl100.bpl } Forms.TApplication.Run (Line 8223, "Forms.pas" + 20) + $3
[0042297A]{bds.exe } bds.bds (Line 195, "" + 7) + $7

Please help me with this.
BR
Jacek

jacek878 · Post by **jacek878** » Wed 17 Jun 2009 22:02

I have forgoten to tell that i`m using win. vista 64bit bussiness

Dimon · Post by **Dimon** » Thu 18 Jun 2009 07:02

Please try to use Windows authentication by setting the TMSConnection.Authentication property to auWindows.

Devart Forums

UNIConnection and problems with remote connection

UNIConnection and problems with remote connection

Re: UNIConnection and problems with remote connection

still the same problem