We help IT Professionals succeed at work.

Connection String Help

narmi2
narmi2 asked
on
Medium Priority
928 Views
Last Modified: 2012-06-27
Hi

I would like to link my application to SAGE Payroll and have read from the web that I can use an odbc connection to link to the SAGE Payrol database.

Does anyone know what this connection string is and/or how I find out what the connection string is?

Thanks
Comment
Watch Question

Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Hi narmi2,

Dim UID,PWD,DSN
UID="username"
PWD="password"
DSN="SageLine50v7"

Set rs=server.createobject("adodb.recordset")
Set cn = Server.CreateObject("adodb.Connection")  
On error resume next
Connect = "DSN=" & DSN
cn.Open Connect, UID, PWD  

Aneesh

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Hi

If Payroll is installed then it will create an ODBC connection called Payroll32.  Line 50 is the Sage accounts package.  

Peter

 
CERTIFIED EXPERT
Top Expert 2006
Commented:
Do you have the ODBC drivers? By what Petermcg001 is saying, it should be there

Depending on what u use, (I dont know whats available), u could try this site, http://www.connectionstrings.com which has lots of different connection types. There is also a general DSN for ODBC connection string, that may work for you.

Craig YellickDatabase Architect
Commented:
You can access a very handy connection string builder like so:

1. Create a new, blank text file (.txt file extension).

2. Rename the file extension to .udl  (universal data link)

3. Double-click the .udl file.

4. A connection string builder is displayed. Select your driver from the list, then move through the other tabs until you have configured the connection. There is a Test button to test it.

5. Close the dialog, the connection string is written to the file.

6. Rename back to .txt and you'll be able to see the string in Notepad.

This builder is for OLEDB drivers but there's an ODBC compatibility driver that might do the trick.

-- Craig

Author

Commented:
Thanks for the info!

The sage software is on a computer in accounts.  I am unable to find the odbc driver on my computer!

How do I get it on my computer without installing sage on my computer.

I want to be able to link to sage from my computer.

Thanks
CERTIFIED EXPERT
Top Expert 2006
Commented:
check the sage website, see if they have it for download
it may be in a developer edition pack, perhaps u need to buy it.

Im assuming SAGe has its own ODBC driver since all the backend DB's Ive connected to have their own
unless they make use of another one
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.