Re: SQL Server connection
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 04/30/04
- Next message: Brian Bushay TeamB: "Re: Design a table"
- Previous message: Brad White: "drop MS_SQL database"
- In reply to: nazeer: "SQL Server connection"
- Next in thread: nazeer Jr.: "RE: SQL Server connection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 29 Apr 2004 21:40:28 -0500
>I just want to know why does the following error come up:
>"[DBNETLIB][Connection Open(Connect()].SQLServer does not exit or access denied". What does it mean Connection Open?
>
You are trying to connect to an SQL server that does not exist or is not running
or the network connection to it is down.
>Also I want verify my ADO Connection Linking. I usually, open my ADO Connection when the main form creates itself. I use the following convention:
>
>Try
> ADOConnection.Open;
>Except
>On E:Exception do
> ADOConnection.Close;
>End;
>
>Is this the standard way to connect the ADOConnection, if it is not how do you all connect the ADO to SQL Server 2000?
If you get an exception on opening you don't have to close. You want to
generate an error. Next your Except will trap any errors when your code is run
except when you run out of the IDE so it isn't good code.
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: Design a table"
- Previous message: Brad White: "drop MS_SQL database"
- In reply to: nazeer: "SQL Server connection"
- Next in thread: nazeer Jr.: "RE: SQL Server connection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
