How do I translate this into a connection string?

[kelly d via AccessMonster.com]

I need to connect to a remote DB so I can make a report making app. I called
my IT people for a connection string and after a month of pulling teeth and
twisting arms, I finally got this .ini file from them that might be useful or
it might not. I cant seem to figure out whats my data source and whats my
initial catalog for making an ADODB connection out of this list of variables
in this .ini file. this is the contents of this file I got:
DBMS=MSS Microsoft SQL Server 6.x
Database=ADSERV
UserId=
DatabasePassword=
LogId=x
LogPassword=x
ServerName=sqlcpgo0
DBParm=OJSyntax='PB',Secure=1
Lock=
Prompt=FALSE
AutoCommit=FALSE

is my data source the ServerName, would my initial catalog be the database
name? or does this info even have all of what I need? I'm guessing my
provider would just simply be sqloledb.

thanks for any help
Kelly D

 

[Guest]

I haven't used ADODB, but I just came across this web site:

Main page:
http://www.connectionstrings.com

ADO ENUMERATIONS:
http://www.connectionstrings.com/adoenumerations.asp


Maybe this will help....

 

[kelly d via AccessMonster.com]

thank you. I will look into your links