Error trying to import journals from sql sever

Posted By Marcos over 7 years ago

I got this error when i'm trying to import data from sql server

Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DatabaseName" requested by the login. The login failed.

user and password has access to sql server

0 Jay Converse Acumen over 7 years ago

Huh?? Exactly what file are you importing, and inside what program?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Jay Converse Acumen

I just try to import data from sql server, but i got that error
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to Marcos

Which program/UI?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Jay Converse Acumen

sage 300 erp 2012
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Marcos

The batch list
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to Marcos

Which UI? GL Batch List? Using File/Import from an ODBC DSN?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to Marcos

Importing _exactly_ what?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Jay Converse Acumen

I'm importing journals from GL Batch List using import ODBC
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to Marcos

Use a DSN that has Windows authentication to SQL.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Marcos

got it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Marcos

now show me another error the connection failed, could not open the connection
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Marcos

Why can not connect using odbc to sql server ?,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to Marcos

You can. Check your windows user ID's permissions in SQL Management Studio.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Marcos over 7 years ago in reply to Jay Converse Acumen

that my string to connect, but i will check the user permissions

<DBNAME>DRIVER=SQL Server;SERVER=myserver;UID=user;PWD=passw;DATABASE=databaseName</DBNAME><DBTYPE>ODBC</DBTYPE>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 7 years ago in reply to Marcos

DSN=SAMINC;Trusted_Connection=Yes;APP=;WSID=mypc;DATABASE=SAMINC;
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Error trying to import journals from sql sever

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING