Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB and Mas90 ODBC Connection....

Status
Not open for further replies.
swhitlow

swhitlow

Programmer
Mar 5, 1999
3
0
0
US
I am trying to access a Mas90 system using ODBC. I've been successful in connecting but I have one problem. The login screen keeps popping up whenever you connect. I was wondering if there is anyway at all around this. Here is my current connect string:

objConn.Open "DSN=SOTAMAS90;Directory=\\fileserver\acctapp$\mas90;SERVER=fileserver"

I've also tried this connect string:

objConn.Open "DSN=SOTAMAS90;Directory=\\fileserver\acctapp$\mas90;SERVER=fileserver;UID=username;PWD=password;CompanyCode=companycode"

But I haven't had any luck. I need to pass the username, password and company code and not have the login screen to come up. Any suggestions? Thanks!
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
184
Kennymc
Kennymc
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
175
sal21
sal21
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
276
LyleU
LyleU
Alexandrefb
  • Locked
  • Question
Cannot add Olap connection
Replies
2
Views
163
hilfy
hilfy
PeaEssEl
  • Locked
  • Question
ASP.Net Crystal Reports connection to SQL Server through published website
Replies
2
Views
60
PeaEssEl
PeaEssEl

Part and Inventory Search

Sponsor

Back
Top