Home > Archive > Cobol > April 2004 > Connecting to MS-SQL Server via ADO (MF NE)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connecting to MS-SQL Server via ADO (MF NE)
|
|
|
| Hi everybody,
I need to connect to MS-SQL Server 2000 via ADO - do YOU have some code
that shows my how to manage that?
Thank you very much in advance
FT
p.s.: I'm using Micro Focus Net Express 3.1
| |
|
| FT wrote:
> Hi everybody,
>
> I need to connect to MS-SQL Server 2000 via ADO - do YOU have some code
> that shows my how to manage that?
Assuming you've got a DSN called "MyDB", something along the lines of
DSN=MyDB
should work for your connection string - then, supply an appropriate
user name and password.
If you can't set up the DSN, check MSDN for the ConnectionString
property for SQL Server - I can't remember the exact string at this point.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~ / \ / ~ Live from Montgomery, AL! ~
~ / \/ o ~ ~
~ / /\ - | ~ LXi0007@Netscape.net ~
~ _____ / \ | ~ http://www.knology.net/~mopsmom/daniel ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ I do not read e-mail at the above address ~
~ Please see website if you wish to contact me privately ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
| |
|
| Thanks for your answer,
but, ConnectionString is not my problem - how and which ActiveX control
to use for the connection was what I thought to be asking for.
FT
BTW: I assume your answer was about ODBC connections, I do need an ADO
connection (-> ADO has no DSN, but DataSource/DateBase)
LX-i schrieb:
> FT wrote:
>
>
>
> Assuming you've got a DSN called "MyDB", something along the lines of
>
> DSN=MyDB
>
> should work for your connection string - then, supply an appropriate
> user name and password.
>
> If you can't set up the DSN, check MSDN for the ConnectionString
> property for SQL Server - I can't remember the exact string at this point.
>
>
| |
|
| "FT" <a@b.com> wrote in message news:406FB950.4040606@b.com...
> Thanks for your answer,
>
> but, ConnectionString is not my problem - how and which ActiveX control
> to use for the connection was what I thought to be asking for.
>
Have you done a Google Search?
For instance:-
http://msdn.microsoft.com/library/d...usingadonet.asp
| |
|
|
|
| FT wrote:
> Thanks for your answer,
>
> but, ConnectionString is not my problem - how and which ActiveX control
> to use for the connection was what I thought to be asking for.
>
> FT
>
> BTW: I assume your answer was about ODBC connections, I do need an ADO
> connection (-> ADO has no DSN, but DataSource/DateBase)
Ah - my apologies. I believe you'll need the ADODB.Connection object to
manage the connection, and the ADODB.Recordset object to retrieve data.
(Those aren't the exact .NET names - don't know if you're in that
environment or not - but maybe it'll give you a place to look... :> )
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~ / \ / ~ Live from Montgomery, AL! ~
~ / \/ o ~ ~
~ / /\ - | ~ LXi0007@Netscape.net ~
~ _____ / \ | ~ http://www.knology.net/~mopsmom/daniel ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ I do not read e-mail at the above address ~
~ Please see website if you wish to contact me privately ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
|
|