Access Filemaker Database Using C# Via ODBC
Aug 17, 2004
Hi, does anybody know how to access data in filemaker using ODBC.
I have read the help files that we can connect to filemaker database via ODBC.
I have tried to create DSN for that, but when I tried to connect using that DSN my C# application, It failed to retrieve the catalog information, it said that login failed.
I have no idea what the username and password that I have to used in my connection because as i knew that filemaker only use password, and i have tried to use that password too.
I never used filemaker before, but this time i need to retrieve data from filemaker, so please help :)
Thanks.
View 2 Replies
ADVERTISEMENT
Nov 16, 2005
I've been programming in Paradox since DOS, but one mail-order database is getting rather large (100K client records, and associated orders, etc).
Our client wants us to move to Filemaker. In fact he'd like to have a 3rd party write the programme and me maintain it. The current package has been written & maintained by myself, with an awful lot lot going on in the Object PAL code.
I already have a copy (legal) of SQL Server & 10 licences for Access, and think that's a better option to re-develop in (although I could do with some training in both).
What are the pros & cons for each app, and what would people recommend. I'm going to cross-post into Access, Paradox & Filemaker forums to get an equal view.
Thanks
Mark
View 9 Replies
View Related
Sep 10, 2012
We have a SQL database that uses Active Directory with Windows Authentication. Can users that are members of the Active Directory group that has read/write access to the SQL database create ODBC connections to access the database directly and update the data? They dont have individual logins on the server. They are only members of the Active Directory group that has a login?
View 1 Replies
View Related
Feb 29, 2008
I need detailed instructions on how to connect to a database from a Microsoft Access 2007 database to a Microsft Office Accounting 2007 database. The accounting database is an SQL 2005 datbase. It has an instance name of "MSSMLBIZ".
When I try I get an SQL error 53. Do not have permissions or database does not exist.
Thanks in advance for any help.,
View 1 Replies
View Related
Feb 27, 2007
Hi,
My task is simple, I want to use the execute sql task editor to grab a value from a database in Access and put it in a variable. The connection is via ODBC and the access database is protected by a password.
I've done all the preliminary stuff such as running profiler to make sure that the package is getting the call to the database, setting up the ResultSet to be "single row" in the general tab, mapped the Result Set correctly, but nothing works. I get the same error every time.
This is my sql command:
select count(FingerPrintID) as FingerPrint
from Employee
Result Set is set up like this:
Result Name: FingerPrint ; Variable Name: User:: varDataset
Here is the error I get:
Error: 0xC002F309 at Execute SQL Task, Execute SQL Task: An error occurred while assigning a value to variable "varDataset": "Value does not fall within the expected range.".
My variable is set up as a Int16.
Please help!!!!!
If you could provide step by step example's that would really make my day.
Thanks,
Lawrence
View 7 Replies
View Related
May 13, 2007
Hi,
I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".
When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.
How can I use DDL statements via ODBC?
I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.
Thanks for help!
Regards,
Stefan D.
View 14 Replies
View Related
Jan 12, 2000
Hi Everyone,
I have set up a link from ACCESS to a SQL 7.0 database using ODBC (File DSN saved on a shared DRIVE). The link works well only from the workstation where the link was created. But How can I create a link so a group of users can view the linked table in ACCESS without type a password? Any suggestion is appreciated.
Lunjun
View 2 Replies
View Related
Feb 13, 2007
I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.
I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
View 4 Replies
View Related
Jul 20, 2005
I am new to filemaker, and i was wondering if there is any solutionout there to export date from filemaker to SQL Server in an automatedprocess?
View 1 Replies
View Related
Dec 26, 2006
When I import from filemaker it gives me a error. Is it any way I can disable the datatypes, so that it willl accept the strange datatypes in SQl Server? I think it's a way in DTS.
View 1 Replies
View Related
Jul 20, 2005
is there any way to import from filemaker with an automated process?
View 1 Replies
View Related
Mar 28, 2008
Hi,
I need to set up an automated transfer of data from a FileMaker database to a SQL 2000 database, so I can build a cube on these data.
Is it possible to make a connection via ODBC to make this datatransfer possible? Is the ODBC driver a part of the FileMaker package or do I have to tell my customer to purchace an add on application?
Hope someone can aid me
View 1 Replies
View Related
Feb 21, 2004
Has anyone successfully connected to FileMaker using SQL Server's Linked Server feature? I've tried every possible combination of entries into the Linked Server dialog box, but no success. I know my ODBC System DSN works because I can extract and update data in FileMaker using MS Query (from within Excel).
Thank you,
View 2 Replies
View Related
Feb 19, 2004
I've developed a number of databases in FileMaker for a client, and am now in the process of converting them over to SQL Server. During the transition, there will be duplicates of tables in both platforms, so I must design a method of data synchronization, so that data maintenance need only be done in one database, not both. I've done it with DTS, but that's certainly not the most efficient. Instead, I'm trying to implement Linked Servers within SQL Server so that data can be updated dynamically with SQL statements. Has anyone ever had the pleasure of trying to do this? If so, would you mind sharing with me how you completed the Linked Server dialogue box (see attached) to connect to FileMaker.
View 3 Replies
View Related
Jul 5, 2007
I have created a SQL Server Database and connected it to an MS Access front end using an ODBC datasource connection.
All reports and queries are in Access and I think that because the queries are in Access and not on the SQL that all data is being transferred across the network and that the data is actually being processed on the client-side. (It's getting slower as more data is entered).
How can I link a SQL Server query through my ODBC connection so that the query is being processed on the server and only the results are being sent across the network?
Thanks in advance for any advice.
Ryan
View 3 Replies
View Related
Dec 29, 2007
Does anyone know how to set up linked database to SQL using MS Access but not having to use ODBC.
Right now we set up ODBC and the access developers use this to link to SQL Server.
We want to get rid of all ODBC settings and i cannot find a way to use MS Access without having ODBC.
Thanks
View 1 Replies
View Related
Jul 24, 2007
We are trying to restict internet access from certin computers but, it's still in place because we need to process credit cards. Is it possible to remove internet access and allow our SQL based program to still run credit cards because of the ODBC connection to the SQL server which has internet access?
View 4 Replies
View Related
Sep 15, 2006
We have this fairly simple Access database with a link table to a view in an SQL Server. The Select Query in Access is a simple select from this view with a view criteria set. Nothing fancy. What is driving is moderately crazy is that this Select Query in Access seems to work fine for months and than all of a sudden (same query performed around the same time with about the same workload on the SQL-Server) it responses with the helpful "ODBC-Call Failed" message. Closing the Access database, taking a coffee, coming back againg and try the exact same Select Query normally works, no "ODBC-Call Failed" message.
It not happens always, mosty we're fine.
When it happens it happens for all subsequent queries tried. We have to close and reopen the Access database and pray to the good Lord that it works.
We would be very interested in someone with a solution to this problem.
View 20 Replies
View Related
Apr 11, 2006
When I choose ODBC from the link tables wizard it just disapears. No error message at all just poof. Any one have any ideas?
Thanks
View 10 Replies
View Related
Aug 24, 2006
I'm attempting to connect to an SQL Server Express database from a remote PC, but it isn't connecting. I have a user account created in the database, and I'm using the SQL authentication with that user account. I have success with this if I'm on the server that the database is on, but not remotely. Both are on the same network, even plugged into the same hub. There doesn't appear to be any network problems.
Any ideas? Thanks!
View 1 Replies
View Related
Nov 14, 2007
I am having an issue that i can't seem to resolve. By no means am I an expert with odbc connections and what not but any help would be great.
here is my issue. I have a 64 Bit terminal server that is running MS Access. I have defined my DSN within the 32 bit admin utility and it connects without a problem As soon as i try to link tables and make a connection to the database from within Access i recieve an "ODBC CALL FAILED" message.
I enabled tracing and here is what i got.....this doesn't mean anything to me but hopefully it does to someone.....
PaintJobShip_Ma 1388-ecc ENTER SQLAllocEnv
HENV * 002DB3C4
PaintJobShip_Ma 1388-ecc EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x002DB3C4 ( 0x07f42538)
PaintJobShip_Ma 1388-ecc ENTER SQLAllocConnect
HENV 07F42538
HDBC * 002DB4D4
PaintJobShip_Ma 1388-ecc EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC * 0x002DB4D4 ( 0x07f425e0)
PaintJobShip_Ma 1388-ecc ENTER SQLSetConnectOption
HDBC 07F425E0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
PaintJobShip_Ma 1388-ecc EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 07F425E0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
PaintJobShip_Ma 1388-ecc ENTER SQLSetConnectAttrW
SQLHDBC 07F425E0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
PaintJobShip_Ma 1388-ecc EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 07F425E0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
PaintJobShip_Ma 1388-ecc ENTER SQLDriverConnectW
HDBC 07F425E0
HWND 000800D4
WCHAR * 0x4BF78088 [ -3] "****** 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
PaintJobShip_Ma 1388-ecc EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 07F425E0
HWND 000800D4
WCHAR * 0x4BF78088 [ -3] "****** 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
DIAG [S1000] [Oracle][ODBC][Ora]ORA-06413: Connection not open.
(6413)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4458
SWORD 4095
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (6413)
WCHAR * 0x036A4458 [ 102] "[Oracle][ODBC][Ora]ORA-06413: Connection not open. a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0"
SWORD 4095
SWORD * 0x002DB3C8 (102)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A44D6
SWORD 4032
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (0)
WCHAR * 0x036A44D6 [ 66] "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
SWORD 4032
SWORD * 0x002DB3C8 (66)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A456C
SWORD 3957
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (0)
WCHAR * 0x036A456C [ 66] "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
SWORD 3957
SWORD * 0x002DB3C8 (66)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4602
SWORD 3882
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4602
SWORD 3882
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc ENTER SQLFreeConnect
HDBC 07F425E0
PaintJobShip_Ma 1388-ecc EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 07F425E0
any help would be great....thanks.
View 3 Replies
View Related
Nov 28, 2006
Hi,
I want to import into an MDB table a csv file.
I'm trying to use the bulk copy table.
my function is:
SQL = "SELECT * INTO [my_table] FROM [ODBC;Driver=Micrsoft text driver (*.txt; *csv) ;Dbq=c:\;Extensions=asc,csv,tab,txt;].table.csv"
db.OpenEx( "Driver=Microsoft Access Driver .mdb);DBQ=c:\access.mdb;", CDatabase::noOdbcDialog );
db.ExecuteSQL( SQL );
when i run this function i get an error : "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database"
when i try to import in the same way a dbf file (insted the csv file) with VFP it's working well.
what seems to be the problem? how can i fix it? or if some one know how can i import a large csv file into access DB in an efficient diffrent way?
thanks ishay
View 1 Replies
View Related
Jun 3, 2004
I have a stored procedure written in MS SQL Server2000 which takes argument(OUTPUT) as a cursor, and fills in the cursor with the record from the table.
I have to run this stored procedure from my C application program running in SUN OS2.9 with the help of ODBC calls.
Can anyone guide me through steps as to how to run the store procedure from my C program and receive records with the help of the cursor.
The store procedure is as follows
CREATE PROCEDURE testCursor @xyzCursor cursor varying OUT AS
DECLARE temp CURSOR
LOCAL
FOR SELECT * FROM table
OPEN temp
SET @xyzCursor=temp
RETURN(0)
GO
View 3 Replies
View Related
Oct 30, 2007
Hi
I'm running a machine with windows xp pro sp2. I have a MS Access 2000 database on that machine. The database contains 1 odbc linked table
and 1 Access query.
The odbc linked table is connected to a MS SQL Server 2000 database with a ODBC SQL Server System DSN.
The table on SQL Server to which the table in Access is linked has about
3 million + rows.
When I open the ODBC linked table in Access, it opens without a problem.
However, if I use even so much as one criterion such as "where company = ABC" for example, then it "thinks" for a while and returns the dreaded:
[Microsoft][ODBC SQL Driver] Timeout Expired (#0).
I have to use MS Access 2000 as the front end for this SQL Database table.
How do I get around the timeout issue. Is there a setting in SQL?
Please keep in mind that
I can't write the queries as Store procs because the requirement of the client is that there be one Linked Access table that the users can use
to write various access queries. No user are not techies.
please help
View 1 Replies
View Related
Jul 16, 2013
I am trying to setup an ODBC data source for Access. The server I'm trying to connect to is 2008 R2. I have SQL Server Management Studio installed on the computer where I'm trying to make the ODBC Data Source from. I can connect the the remote 2008 server through Management Studio, but in the ODBC wizard I do the following:
"Machine Data Source" tab, click "New"
Select "User Data Source", click "Next >"
Select "SQL Server", click "Next >"
Click "Finish"
Name: remote
Description: remote
Server: type the server name ie "sql.somewhere.com"
[code]....
View 11 Replies
View Related
Sep 27, 2006
I have access97 front end , with linked tables to sql server 2005. when i change a table ID column (type int) to primary key so it is updatable, then try open the table i get odbc error with no msg, if i alter table again to remove primary key option table opens fine but is not updateable. any ideas would be a great help
View 5 Replies
View Related
Mar 2, 2007
I am migrating my development environment from XP Pro to Vista, and my website is now serving up the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
The code in question is as follows:
set dbConn = Server.CreateObject("ADODB.Connection")
szPath=Server.MapPath("../../../")
szProvider="Driver=Microsoft Access Driver (*.mdb); DBQ=" & szPath
szProvider=szProvider & "database" & szDir & "" & szDB & ".mdb;"
if bDebug then fpDebug.WriteLine("szProvider: " & szProvider)
dbConn.Open szProvider
The error happens on the last line where I try to open the connection. I've tried also using a dbConn.Provider="Microsoft.Jet.OLEDB.4.0" line, to no avail. The item that is passed to the Open command is
Driver=Microsoft Access Driver (*.mdb); DBQ=C:obstuffdatabasedemoHMGA.mdb;
I'm not familiar enough with DNS and IIS to figure this out. Any suggestions -- other than porting over to SQL and .NET? You don't buy a Ferrari when you only drive in a 30 MPH town.
View 7 Replies
View Related
Nov 8, 2006
So far I've been unable to connect to a test SQLServer Everywhere/Compact database with MS Access. I installed the new SQLServer 2005 Native Client to no avail. Has anyone done this?
View 10 Replies
View Related
May 24, 2007
I just installed SQL 2005 on a backup/test server. When I connected with ODBC to the new server I lost all of my ODBC connections, even to the working server (SQL 2000). I did a full repair on XP and got the ODBC to connect. Why would connecting to SQL 2005 cause my ODBC to crash ?. I tried using SQL Native as well, with no joy to either server. My ODBC isn't working again. The problem began as being intermittent, i.e. connected one minute, lost connection the next. Now it's permanently disconnected and I'm not even sure the reinstall was a solution.
View 4 Replies
View Related
Dec 13, 2007
I have a weird problem.
I have an SQL Server running my database, I connect to it through a VPN, I'm linking tables with it using ODBC from my Access database. I can see the data without problems. But when I attempt to run a query in my Access which basically creates a local copy of a table I sometimes get the following error: -7776.
After having searched a bit for the error, I found out that it is an ODBC error that is concerning date/time conversion.
-7776 SQLGetData(SQL_C_TIMESTAMP)
Illegal date/time value returned.
I do not have any timestamp datatypes in my SQL server table, they are all datetime datatypes. I have checked the data, all of the dates seem legal dates, no NULL values.
The problem is not consistent, it does not occur at every attempt, it appears about every third time but not consistently. And not at the same location each time. If I stop importing my datetime column, I avoid the error.
From my home location I do not get the error, and neither if I run without my company firewall. However from within the company firewall the error occurs at random times, and at random locations (always the datetime column though).
I find this extremely weird, and even though the problem could seem to be my firewall I somewhat doubt that, since I'm able to see the data if I use a SELECT query, but not when making a Make table one. And since it is always concerning my datetime column (which is not called datetime, datetime is simply the datatype).
I am using Access 2003 and SQL Server 2005.
If you need any further details, please do not hesitate to write.
View 4 Replies
View Related
Oct 23, 2007
Hi
I'm building a data warehouse - my end users connect using Access via ODBC Microsoft SQL Server driver (2000.85.1117.00).
However, whenever they connect using Access via ODBC they get a huge list of sys and INFORMATION_SCHEMA views, in addition to the data warehouse tables they need to access.
How can I remove these sys and INFORMATION_SCHEMA views from the list of tables/views presented to the end user?
I've tried denying access by changing permissions to deny in the public role of the master database - I have also changed permissions in the public role in the data warehouse database. When I do this, the ODBC connection fails to retrieve any objects because it doesn't have access to sys.databases (and various other unspecified objects).
I'm stuck - help!
View 4 Replies
View Related
Jul 23, 2005
Hello all!I have such question to all of you.I have some tables linked from MS SQL Server 2000. Is time of processingquerybased on these linked tables from MS SQL Server 2000, faster or slower thanthe time of processing the same query based on tables, which are not linkedbutimported to MS Access?Can you answer this question?Thank you in advance for postsMarcin from Poland.
View 1 Replies
View Related
Jul 20, 2005
How viable is it to use MS Access as a front end (via ODBC) to a SQL Server2000 database?The users would access via the internet using a netgear vpn setup.Thanks,Paul S
View 1 Replies
View Related
