BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Cannot connect to SQL Server from Delphi ADO          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Todd Cary Guest Posted: Wed Jun 07, 2006 6:56 pm    Post subject: Cannot connect to SQL Server from Delphi ADO I have a very strange bug in on my Toshiba notebook running XP Professional and the latest SP's along with Delphi 5 (yes, it is old ). On the notebook I have a copy of SQL Server local. From the Enterprise Manager I can access it as well as see other SQL Server applications on the LAN. From other work stations I can see the local version. Here is the problem: Some months ago I downloaded some update from Microsoft (for the life of me I cannot remember what it was) and installed it. From that point on I DO NOT see the local server if I try to create a Connection String using the wizard for the ADO Connection component though I see others (if I am on the LAN). Even reinstalled SQL Server local (cannot remember the official name for the local version). The notebook is seldom used; it is just to have a copy of the custom apps I maintain for my clients if I am on the road. Any suggestions? Todd Back to top Alain Quesnel Guest Posted: Wed Jun 07, 2006 11:44 pm    Post subject: Re: Cannot connect to SQL Server from Delphi ADO What if you manually create the connection string, based on a period (represents the local machine) for the server name? Or maybe you have a named instance of SQL Server? -- Alain Quesnel alainsansspam (AT) logiquel (DOT) com www.logiquel.com "Todd Cary" <todd (AT) aristesoftware (DOT) com> wrote in message news:4486DB15.6090204 (AT) aristesoftware (DOT) com... Quote: I have a very strange bug in on my Toshiba notebook running XP Professional and the latest SP's along with Delphi 5 (yes, it is old ). On the notebook I have a copy of SQL Server local. From the Enterprise Manager I can access it as well as see other SQL Server applications on the LAN. From other work stations I can see the local version. Here is the problem: Some months ago I downloaded some update from Microsoft (for the life of me I cannot remember what it was) and installed it. From that point on I DO NOT see the local server if I try to create a Connection String using the wizard for the ADO Connection component though I see others (if I am on the LAN). Even reinstalled SQL Server local (cannot remember the official name for the local version). The notebook is seldom used; it is just to have a copy of the custom apps I maintain for my clients if I am on the road. Any suggestions? Todd Back to top Todd Cary Guest Posted: Thu Jun 08, 2006 8:07 pm    Post subject: Re: Cannot connect to SQL Server from Delphi ADO When I tried that, it gave an error message saying it could not find the server. I NEVER should have downloaded and installed that MS security fix!! Put the authentication program on my computer to make sure I am using a proper version of XP...damn! Todd Alain Quesnel wrote: Quote: What if you manually create the connection string, based on a period (represents the local machine) for the server name? Or maybe you have a named instance of SQL Server? Back to top Bill Todd Guest Posted: Thu Jun 08, 2006 8:24 pm    Post subject: Re: Cannot connect to SQL Server from Delphi ADO The Delphi ADO components are just a lightweight wrapper around Microsoft's ADO components. Event the dialog that you use to build a connection string or select a UDL file is from Microsoft. Since you cannot see the local server in the connection string dialogs you know that Microsoft's components cannot see it. Therefore, if you do not get an answer here you might try posting in the appropriate Microsoft SQL Server newsgroup and not mention Delphi. Just start with the fact that you cannot see the server when you try to build a connection string and go from there. -- Bill Todd (TeamB) Back to top Viatcheslav V. Vassiliev Guest Posted: Fri Jun 09, 2006 12:36 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO Can you have firewall blocking access to MS SQL Server? //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Todd Cary" <todd (AT) aristesoftware (DOT) com> ???????/???????? ? ???????? ?????????: news:44883ca3$1 (AT) newsgroups (DOT) borland.com... Quote: When I tried that, it gave an error message saying it could not find the server. I NEVER should have downloaded and installed that MS security fix!! Put the authentication program on my computer to make sure I am using a proper version of XP...damn! Todd Alain Quesnel wrote: What if you manually create the connection string, based on a period (represents the local machine) for the server name? Or maybe you have a named instance of SQL Server? Back to top Oliver Townshend Guest Posted: Fri Jun 09, 2006 3:16 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO Quote: I NEVER should have downloaded and installed that MS security fix!! Put the authentication program on my computer to make sure I am using a proper version of XP...damn! No one else in this group is having this problem, so I suspect you are blaming the wrong thing. What is your connection string? Oliver Townshend Back to top Todd Cary Guest Posted: Fri Jun 09, 2006 5:49 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO It ("I") cannot make it since the Local server is not listed. Todd Oliver Townshend wrote: Quote: I NEVER should have downloaded and installed that MS security fix!! Put the authentication program on my computer to make sure I am using a proper version of XP...damn! No one else in this group is having this problem, so I suspect you are blaming the wrong thing. What is your connection string? Oliver Townshend Back to top Oliver Townshend Guest Posted: Fri Jun 09, 2006 6:35 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO Quote: It ("I") cannot make it since the Local server is not listed. Have you tried localhost? Or 127.0.0.1? Or . (thats a full stop or period)? Oliver Townshend Back to top Todd Cary Guest Posted: Fri Jun 09, 2006 8:11 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO Bill - Thank you...good advice... Todd Bill Todd wrote: Quote: The Delphi ADO components are just a lightweight wrapper around Microsoft's ADO components. Event the dialog that you use to build a connection string or select a UDL file is from Microsoft. Since you cannot see the local server in the connection string dialogs you know that Microsoft's components cannot see it. Therefore, if you do not get an answer here you might try posting in the appropriate Microsoft SQL Server newsgroup and not mention Delphi. Just start with the fact that you cannot see the server when you try to build a connection string and go from there. Back to top Todd Cary Guest Posted: Fri Jun 09, 2006 8:11 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO Unfortunately, it was the MS download (fix one thing and break something else). Ms has a fix for it that got me back in business. This chap went through what I did but was smarter and used Google: http://www.doughughes.net/index.cfm?event=viewEntry&entryId=91 Todd Oliver Townshend wrote: Quote: I NEVER should have downloaded and installed that MS security fix!! Put the authentication program on my computer to make sure I am using a proper version of XP...damn! No one else in this group is having this problem, so I suspect you are blaming the wrong thing. What is your connection string? Oliver Townshend Back to top Todd Cary Guest Posted: Fri Jun 09, 2006 8:11 am    Post subject: Re: Cannot connect to SQL Server from Delphi ADO Got it working! Here is what I found via Google: Apparently, if you have an out of date version of the file DBNETLIB.dll Server 2003 and XP Service Pack 2 disables TCP/IP access to MS SQL Server. This is a defense against the Slammer worm. By going to http://www.doughughes.net/index.cfm?event=viewEntry&entryId=91 , one gets a reference to a MS patch. Todd Todd Cary wrote: Quote: I have a very strange bug in on my Toshiba notebook running XP Professional and the latest SP's along with Delphi 5 (yes, it is old ). On the notebook I have a copy of SQL Server local. From the Enterprise Manager I can access it as well as see other SQL Server applications on the LAN. From other work stations I can see the local version. Here is the problem: Some months ago I downloaded some update from Microsoft (for the life of me I cannot remember what it was) and installed it. From that point on I DO NOT see the local server if I try to create a Connection String using the wizard for the ADO Connection component though I see others (if I am on the LAN). Even reinstalled SQL Server local (cannot remember the official name for the local version). The notebook is seldom used; it is just to have a copy of the custom apps I maintain for my clients if I am on the road. Any suggestions? Todd Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.