Member Avatar

Hi all, I have a Windows 7 64 bit client that is running a 32 bit of software and so needs a 32 bit ODBC connection to the database. I of course ignored the Administrative Tools > ODBC manager because that will open the 64 bit and instead went to c:\windows\syswow64\odbcad32.exe to input the system DSN connection. I went through the wizard and when I went to select the database got a message to say the server could not be accessed. I checked on the DB server that the SQL service was running, that the firewall had all necessary ports …

0
11
Member Avatar

I have an application, i'm using C# wtih asp.net I need to generate reports with my database (mysql), so I downloaded Crystal Reports. I'm trying to make the connection between Crystal Reports and my database, for that I've Add the User Data Source (MySQL ODBC 5.1 Driver) in the ODBC Data Source Administrator. That works fine, the Test Connection with my db is succesfull. The problem is, that when I try to add the Data Source in Crystal Reports, I select the data source, fill the connection information and when I click FINISH, this error shows up: *ERROR [IM014] [Microsoft][ODBC …

0
8
Member Avatar

Guys,i want a small help from you.I have a created a database in MS Access and now i want to connect it to with Java Application by using ODBC Administartor.But when opens it,it doesn't show any driver for MS Access DBs.Do u guys know any driver for that.I'm using Windows 7 64-bit version.Please help me ASAP...

0
1
Member Avatar

Hello to all, sorry if my english is not so good, I will try to explain the problem. I need to copy all data from a Table of a Acces mdb (connected with OleDB) to a Table of a MySql DB (connected with ODBC) I made a working solution, but it's very slow, and so I want to try other solutions to check if they can give me more performance. The solution connecting to the mdb, using a DataReader, then for each row in Datareader I make an INSERT into the Mysql Table ( before copy I truncate the table …

0
1
Member Avatar

hi. Im connecting to a oracle network database using power builder 6.0, but I get the following error when I display the window containing the datawindow: [CODE]Predefined message "pfc_dwderror" not found. message arguments: 1)A database error has ocurred Database error code: 942 Database error code message: select error: SQLSTATE=S0002 [microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist[/CODE] this is the odbc script for connection: [CODE]SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = False SQLCA.DBParm = "ConnectString='DSN=xxx;UID=xxx;PWD=xxx;'"[/CODE] once I try to connect to the database, I get the following error: "catalog tables could not be created and are not available for use". …

0
1
Member Avatar

Any ideas on detecting the current version of the MySQL ODBC driver? Currently I am reading the registry to obtain the version: [code=delphi] Function MySQLVersion:String; Var TR : TRegistry; SL : TStringList; I : Integer; Begin Result := 'ODBC 3.51'; // Default version SL := TStringList.Create; TR := TRegistry.Create; TR.RootKey := HKEY_LOCAL_MACHINE; If Not(TR.KeyExists('SOFTWARE\\MySQL AB\')) Then Exit; If TR.OpenKey('SOFTWARE\MySQL AB',False) Then Begin TR.GetKeyNames(SL); I := StartsLineIndex(SL,'MySQL Connector'); // Find the index of the line starting with 'MySQL Connector' If (I>=0) Then Result := RightPart(SL[I],'/'); // Get the right side of the string after '/' End; SL.Free; TR.Free; End; [/code] This …

0
1
Member Avatar

hi, not sure if im posting in the correct section but im working on a site registration for a mate this bit has been completed, however i am wanting to extend this and display a plethora of info but i have hit a bit of a wall. iam wanting to limit the number of results to a page and noticed msspl doesnt use the limit clause, could sombody give me an example or point me to a tute that covers this. I have only found 1 and that wasnt much help. i am using php 5 on iss6 with mssql …

0
1

The End.