| Connecting to Oracle (5 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| C'd anyone send me sample code to connect to oracle from an aspx page. I have installed the client on my m/c but when i run the foll. code, i get an error on the conAuthors.Open() statement. It doesn't seem to be finding the oracle stuff, although when i try to test teh connection from ODBC tester, it works fine. Whats missing? Thanks deepika %@ Import Namespace "System.Data.OleDb" % % Dim conAuth... |
|
| SQLServer Database in access? (5 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Marcie Jones marciejones@yahoo.com Is it possible to open a SQL Server database in Microsoft Access? I find the design tools are far superior to those of SQL Server... Anyone know how to do this? THANX! Gavan Brown |
|
| The Microsoft Jet database engine cannot open the file (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngstart] to [ngfx oledb] by Ken Schaefer ken@adOpenStatic.com Ok, I give up. I am getting this error no matter what I try to do to access an access database to get familer with asp.net as I can't afford sql server to do sql testing. I've installed MDAC 2.7 and made sure I added "aspuser" to the directory (and all files inside) as full control (read,write,change,delete). I erased the... |
|
| unanswered question (9 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| hi all please help me in following code as working... in web.config i have... appSettings add key "strMyDbaseCon" value "Provider Microsoft.Jet.OLEDB.4.0; Data Source c:\inetpub\wwwroot\qtrmgmt\database\qtr.mdb;"/ /appSettings my function is like... Public Sub CreateMyOleDbCommand(ByVal myExecuteQuery As String, ByVal myConnectionString As String) Dim myConnection As New OleDbConnection(myConnecti... |
|
| Need MDAC version 2.6 or later (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngvb] to [ngfx oledb] by James Avery javery@deluxeeng.com I hit a error as following: System.SystemException: The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later. System.Runtime.InteropServices.COMException (0x8007007F): The specified procedure could not be found.... |
|
| OLE DB provider for Oracle. (4 replies) |
| ASPFriends.com 'ngfx-oledb' list |
| Moved from [aspngdata] to [ngfx oledb] by Charles M. Carroll charlesmarkcarroll@yahoo.com Hi, I'm using "Microsft OLE DB provider for Oracle" to connect with oracle. I'm trying to create connection string through .udl file, i specified server name, user and password and then tested the connection, it is giving me the following error. "Test Connection failed because of an error in initializing prov... |
|
| SQL Function (3 replies, VIP) |
| ASPFriends.com 'ngfx-oledb' list |
| MessageI need a function in Oracle SQL to rounded a number but always to the max. Example: if the number is 0,1 the function must return 1 if the number is 0,9 the function must return 1 I tried with ROUND but it doesn't work because when the number is 0,1 the returned value is 0 Thanks Lucas Lodeiro Teletec Soluciones S.A. Tel: 54 (11) 4554 4666 Cel: 54 (11) 5007 6026 |
|
