Question about ACCPAC Simply Accounting 2004 PRO (2120148) for PC

1 Answer

Re if I need create odbc dsn for all workstation?

If I need create odbc dsn on all workstation?
or I only create it on server,on other workstation accpac (workstation
) auto create it during accpac install.

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 14 Answers

Use servername as the server in setup and it will autocreate servername32 in odbc

Posted on Jun 25, 2010

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Which database can I use with ColdFusion?


ColdFusion supports ODBC-compliant databases. With Net Nation's ColdFusion plans, you can use a Microsoft FoxPro, Microsoft Access or Microsoft SQL Server database. ColdFusion supports both DSN and DSN-less connections.

Oct 09, 2014 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

HOW TO CONNECT DATABASE TO VISUA LBASIC 6.0


You'll need to instantiate (create an instance of, or an item in memory) what is known as an ODBC connector. You will also need to create a database or have a database to work with - Microsoft Access will work fine for this, alternatively you can use OpenOffice's version of Access.
The code you'll want to use will be approximately
Dim ws as Workspace dim db as database dim strConnection as string set ws=DBEngine.Workspaces(0) let strConnection= "ODBC;DSN=" & DatabaseName & ";UID=" & UserName & ";PWD=" & UserPassword set db=ws.OpenDatabase("", False, False, strConnection)

Apr 07, 2011 | Microsoft Windows XP Professional

1 Answer

Developing an application with vb.net 2008 and i'm finding it


You need to set up an ODBC DSN and use this in your connection string then instantiate an ODBC connection. For example:

Dim MyConnectionString As String = "Driver={MySQLDSN};SERVER=localhost;DATABASE=MySQLDatabase;" '
Dim conn As New OdbcConnection(connectionString)
conn.Open()
Dim da As New OdbcDataAdapter("SELECT * FROM Customers", conn)
Dim ds As New DataSet()
da.Fill(ds, "Customers")
dataGrid1.DataSource = ds.DefaultViewManager
conn.Close()

Sep 04, 2009 | Microsoft Computers & Internet

1 Answer

Same as above really


Hi,
I have fixed my problem. I realised that the Microsoft Access Database DSN did not include the *.accdb driver. I deleted the existing DSN and created a new one. This allowed me to select the ODBC driver that worked for both file types.

I cameto realise that I was only having this problem on machines that have been upgraded to excel 2007 and not on machines with full virgin installations. On install both try to create the appropriate DSN but one with the same name already exists on the machines being upgraded and the creation fails.

I hope this helps others.

Jul 18, 2009 | Microsoft Excel for PC

1 Answer

I am trying to connect to a SQL Server 2005 DB from Visual Studio


You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.

Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition

1 Answer

How can i connect the data base during my project


That seems fine.

I cant assume your level of confidence in programming, however, following are some simple steps you can follow to achieve (for complex implementations, much more time and details will be needed, i can help u with them as well)

1. Create a database in Access ( i assume u r using Access 2003)
2. Create a System DSN (if aren't clear, how to create then goto administrative tools under control panel and you'll find Data Sources (ODBC), here u need to create System level DSN for Access driver (may be Jet 4.0+)
3. In java, you need to import java core libraries for sql (javax.sql package specially)
4. you are almost done, just google for database code in java, simple code will be around 5-10 lines (just for your reference, search with these keywords, ClassName(""), jdbc:odbc:YourDSN)
5. Open a connection using Connection object
6. Fetch the records (select query) using Recordset object
7. You're done.

thanks
Kuldeep

Mar 13, 2009 | HP Computers & Internet

1 Answer

How can i connect jdbc odbc to do my program


Create a System DSN in Windows XP loadTOCNode(2, 'summary');
  1. Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources(ODBC).
  2. Click the System DSN tab, and then click Add.
  3. Click the database driver that corresponds with the database type to which you are connecting, and then click Finish.
  4. Type the data source name. Make sure that you choose a name that you can remember. You will need to use this name later.
  5. Click Select.
  6. Click the correct database, and then click OK.
  7. Click OK, and then click OK.

Jan 14, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

ODBC


give ur add i want to check it out.

Aug 26, 2008 | Microsoft Windows Server Standard 2003 for...

2 Answers

How to configure odbc for multiple user in windows 2003 server


You can also try adding the datasource as a System DSN instead of a User DSN. Of course, all users on a given system will then have access.

Apr 03, 2008 | Microsoft Windows Server Standard 2003 for...

Not finding what you are looking for?
ACCPAC Simply Accounting 2004 PRO (2120148) for PC Logo

Related Topics:

116 people viewed this question

Ask a Question

Usually answered in minutes!

Top ACCPAC Computers & Internet Experts

yadayada
yadayada

Level 3 Expert

76691 Answers

BJ Russell

Level 2 Expert

214 Answers

Roy May

Level 3 Expert

434 Answers

Are you an ACCPAC Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...