How do I translate this into a connection string?

  • Thread starter Thread starter kelly d via AccessMonster.com
  • Start date Start date
K

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
 
Back
Top