Devart Forums

Posted: **Wed 11 Jul 2007 11:17**

Hi.
There is program written on Delphi5 with SDAC3.50.0.11 for MSDE2000.
It works fine from win95 to winxp.
But there is one computer with win98se what not work. In addition it placed far away from me and no admonistrators inplace, only advanced users. My administration skills not high too.
This is fone discusson result:
While program try to connect the error occured, somthing that "sql server not found". MDAC 2.7 installed. QA and EM connect fine. But when user try to set ODBC connection it sucssesed only if manually set port in "Edit Network Library Configuration". The value was take from EM on server settings. User change value to 1433 afaik default tcpip port for sqlserver. Progam not running yet. There is no attempt to configure ODBC connection with checked "Dinamicaly determine port", try this tomorrow.
What they can do for program prpoper work?

Posted: **Wed 11 Jul 2007 14:26**

I guess, the exact message is "MS SQL not found". This message means that the required OLE DB provider is not registered on the client's computer. Try to download the last version of the provider you use in your application, and install it on the client's computer. If you use the SQLNCLI.1 provider, you should install SQL Native Client.

Posted: **Thu 12 Jul 2007 09:32**

Error message:
[DBNETLIB][ConnectionOpen (Connect()).]SQL-сервер не существует, или отсутствует доступ.
Perhaps in translation - SQL - server does not exists or access denied.
ODBC connection with "Dinamicaly determine port" work fine only with 1433 port setting in EM.
I think oledb provider installed by MDAC. What can i determine correct registration this provider?
I am not directly using provider. Sdac do it, i think.
Connect code:

Code: Select all

  fMSConnection: TMSConnection;

  if fMSConnection=nil then begin
    fMSConnection:=TMSConnection.Create(nil);
    fMSConnection.LoginPrompt:=false;
  end;
  fMSConnection.Server:=Server;
  fMSConnection.Username:=uname;
  fMSConnection.Password:=upwd;
  fMSConnection.Database:=Ctlg;
  screen.Cursor:=crSQLWait;
  application.ProcessMessages;
  try
    fMSConnection.Open;
  finally
    screen.Cursor:=crDefault;
  end;

Now i changed my test DB default port to 1433 and program fired error, but EM worked. After i changed port to 7070 : program not work, EM not work, ODBC not work on any settings.
Additional question: How do i rollback in my machine to restore port settings

Posted: **Fri 13 Jul 2007 15:04**

This exception is not generated by SDAC. This is an OLE DB exception. Most likely this is happening because of wrong configuration of your server.

> Additional question: How do i rollback in my machine to restore port settings
This question is out of SDAC support scopes. Please refer to documentation of your server or MSDN.

Devart Forums

msde win98 sdac connection problem

msde win98 sdac connection problem