Visual Basic

FirstPrevNext

Re: Connection string in VB.Net 2003 Dave Kreskowiak23-Oct-07 2:06 Dave Kreskowiak 23-Oct-07 2:06  The Provider in the connection string should be just "MSDAORA", drop the ".1" part. I also don't know if putting a period in the database name is legal, nor do I know if putting a space in the User Id, "oracle ken", is legal either. OleDb is a kind of "generic" database interface. Like the other poster said, you'd get much better performance if you used the OPD.Net provider instead. This will, of course, require a rewrite of your code. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Connection string in VB.Net 2003 kendo1723-Oct-07 2:30 kendo17 23-Oct-07 2:30  when opening server explorer should the oracle database not be displayed there for me to point to and then test. As the database is not showing there. I tried database connection with my access and it connected successfully but will not connect to the oracle database but it is not displayed in the server explorer. Re: Connection string in VB.Net 2003 Dave Kreskowiak23-Oct-07 3:45 Dave Kreskowiak 23-Oct-07 3:45  kendo17 wrote: when opening server explorer should the oracle database not be displayed there for me to point to and then test. As the database is not showing there. The provider and credentials have to be correct in order for it to connect to the server and get the list of databases. The credentials also have to have permissions in the Oracle server to get that list. I don't know exactly what has to happen on the Oracle server, since I've never used Oracle, nor do I want to. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Connection string in VB.Net 2003 aransiola23-Oct-07 23:04 aransiola 23-Oct-07 23:04  Oracle & SQL Server Databases are server-based database. They are not Filedatabase like Microsoft Access. So they cannot be open like you open ur access db file. The Oracle Database like SQL Server has an Enterprise Console where you can manage the database t.aransiola Re: Connection string in VB.Net 2003 Dave Kreskowiak24-Oct-07 1:13 Dave Kreskowiak 24-Oct-07 1:13  And you're telling me this why??? I know that, and your answer has nothing to do with the problem. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Connection string in VB.Net 2003 AliAmjad22-Oct-07 23:14 AliAmjad 22-Oct-07 23:14  Try the Oracle Managed Provider for .NET and then use the Connection String this will improve the performance of your application. AliAmjad (MCP) About the the .dll version I include in my application albeeeta22-Oct-07 6:31 albeeeta 22-Oct-07 6:31  Hi everybody! I'm developing an application that has to be easy to update, so what I did is a general application that calls diferent dll's. Like this if I change a method that is in A.dll I have only to recomplile this A project and put A.dll in the main application folder. For now everythink fine, but if I change the version of A.dll (when I change something this would be a new version...) and recompile it and replace the old A.dll the main application give me an error... Any Idea what I have to do?? Is has anything to do with the COM interop??I have no idea about this! In project properties there is Signing, what is this about?? I know I have many questions, but I'm new in this... thanks a lot!!! alba Re: About the the .dll version I include in my application Dave Kreskowiak22-Oct-07 8:50 Dave Kreskowiak 22-Oct-07 8:50  When you early bind to a .DLL from another project, part of the fully qualified name in the binding is the assembly version number. The code doesn't just look for the correct filename. It also looks for the correct version is was bound to. It has nothing to do with COM Interop. What you have to do is redirect that binding to the version of the assembly you want it to use. Look in this article[^]. What you're looking for is "BindingRedirect". A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: About the the .dll version I include in my application albeeeta22-Oct-07 20:24 albeeeta 22-Oct-07 20:24  But what I need is be able to change the version of a .dll and don't have to recompile the main application... Is there any way to do that?? Thanks!! alba Re: About the the .dll version I include in my application Dave Kreskowiak23-Oct-07 1:50 Dave Kreskowiak 23-Oct-07 1:50  You didn't read the article, did you? You don't recompile the application. You modify the app's config file and add the BindingRedirect section to tell the loader what the old and new version numbers of the .DLL are. Any binding that goes to the old .DLL version would get redirected to the new version number. All you do is rename the old .DLL, copy in the new one, then make the BindingRedirect changes. Done. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: About the the .dll version I include in my application Dave Kreskowiak23-Oct-07 2:02 Dave Kreskowiak 23-Oct-07 2:02  Don't put this .DLL in the GAC. If it's application specific, Microsoft actually recommends against doing this. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: About the the .dll version I include in my application AliAmjad22-Oct-07 23:09 AliAmjad 22-Oct-07 23:09  Why don't you just assign a strong name to the assembly and install it to the Globle Assembly Cache. This won't only improve the performance of your Application but also allows you to change anything in the assembly without worrying about the versioning conflict. AliAmjad (MCP) Re: About the the .dll version I include in my application albeeeta23-Oct-07 0:49 albeeeta 23-Oct-07 0:49  Do I have to Install it into the global caché assembly or can I just put it on the application folder?? thanks for ur help!!! alba Re: About the the .dll version I include in my application AliAmjad23-Oct-07 1:16 AliAmjad 23-Oct-07 1:16  No install it in the Globle Assembly Cache because CLR actually first explore the assemblies installed in the GAC so It'll be able to discover the assembly in the early stages this way the performance of your application will increase more and you don't have to worry about the version of your application. AliAmjad (MCP) Re: About the the .dll version I include in my application albeeeta24-Oct-07 20:37 albeeeta 24-Oct-07 20:37  thanks for ur help!! alba Need some suggestions. BubbaGeeNH22-Oct-07 6:17 BubbaGeeNH 22-Oct-07 6:17  Currently have a VB6.0 program that is used to monitor/control a device via a serial connection. It is constantly polling the device to keep data up to date and to keep the communication link active. My problem is finding a reliable way to access the data via an external program (written in C++)(ProgC++). The previous programmer has been using "SendMessage" to send information to the VB6.0 program(ProgVB) and setup portions of device but his way of addressing getting information back from the program doesn't work. He was trying to use a similiar "SendMessage" approach but didn't take into account that the SendMessage from ProgC++ until the SendMessage from ProgVB finishes and that will only finish once ProgC++ reads it and acts on it. So it gets stuck in a cycle where neither program will run until the other finishes. Thought of using PostMessage but run into the issue where the data may not be valid in time for me to use it since PostMessage never reports when the message has been handled like SendMessage does. Is there a way to build external subroutines into VB6.0 that I can access from outside of the program? Thanks, George Re: Need some suggestions. Dave Kreskowiak22-Oct-07 9:48 Dave Kreskowiak 22-Oct-07 9:48  SendMessage is the poor-mans hack to IPC. I suggest using REAL Interprocess Communication. There's probably some IPC component out on the web somewhere. I just don't know of any off the top of my head. I stopped using VB6 6 years ago. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Need some suggestions. Christian Graus22-Oct-07 12:15 Christian Graus 22-Oct-07 12:15  Dave Kreskowiak wrote: VB6 6 years ago. Took me a second to realise that wasn't a typo... Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) visual Basic + Excel rpimpley22-Oct-07 2:40 rpimpley 22-Oct-07 2:40  Hi all, I m tryin to write data from Visual Basic (VB) to Excel sheet. I m writing data into three different excel files with one at a time. The logic works fine for writing the data but the problem is displaying the files. First excel is displayed perfectly. But when I write in second excel file & try to open it while the first is opened, the second automatically becomes hidden. This file can only be seen from Excel menu: Windows -> Unhide. Wht must be the problem of file becoming automatically hidden? I hv even written the command of Xlsheet.visible = true but still it doesnt work. Can u pls guide me to identify the problem ??? Thank you. Re: visual Basic + Excel Onisan200022-Oct-07 3:49 Onisan2000 22-Oct-07 3:49  You could set the Workbook visible property to false for the workbook you don't want to see objApp.Workbooks.Add() Dim firstname As String = objApp.ActiveWorkbook.Name objApp.Workbooks.Add() Dim secondName As String = objApp.ActiveWorkbook.Name objApp.Windows(secondName).Visible = False Re: visual Basic + Excel rpimpley22-Oct-07 18:13 rpimpley 22-Oct-07 18:13  Thanx for the reply. Ya I hv done tht but see hiding the worksheet is not my problem. My prb is unhiding the hidden worksheet. Is there any command in VB by which I can unhide the hidden excel worksheet ? Re: visual Basic + Excel Onisan200024-Oct-07 1:18 Onisan2000 24-Oct-07 1:18  ' To set the visible property to True on ALL sheets in workbook Sub Un_Hide_All() Dim sh As Worksheet For Each sh In Worksheets sh.Visible = True Next End Sub How to insert a background image to a webbrowser control? King of Kingz22-Oct-07 2:05 King of Kingz 22-Oct-07 2:05  Hi, i m building a html editor, all i want is how to insert a background image. I have done it by replacing the tag with but i wana somthing more professional... plz help me... King Re: How to insert a background image to a webbrowser control? Vasudevan Deepak Kumar22-Oct-07 4:22 Vasudevan Deepak Kumar 22-Oct-07 4:22  You also seemed to have posted this query in C# forum! Vasudevan Deepak Kumar Personal Homepage Tech Gossips Reg:Image Data retrival Form SQL SERVER 2000 Satish_S22-Oct-07 1:15 Satish_S 22-Oct-07 1:15  hi , I am having an HTML file Control and if i click add image button to save the image in DataBase, it is getting Save in Database in Format <Binary> Format. when i am trying to retrive the Image from Database the Image getting Read but no images are displaying i do no Where the Issue is can any one help me to solve this problem <code> Private Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click intImageSize = fileUploadCTRL.PostedFile.ContentLength strImagetype = fileUploadCTRL.PostedFile.ContentType ImageStream = fileUploadCTRL.PostedFile.InputStream Dim ImageContent(intImageSize) As Byte intsize = ImageStream.Read(ImageContent, 0, intsize) Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR")) Dim sqlcommand As New SqlCommand("sp_Image", sqlconn) sqlcommand.CommandType = CommandType.StoredProcedure Dim sqlParams As New SqlParameter("@PersonImage", SqlDbType.Image) sqlParams.Value = ImageContent sqlcommand.Parameters.Add(sqlParams) Dim prmPersonImageType As New SqlParameter("@PersonImageType", SqlDbType.VarChar, 255) prmPersonImageType.Value = strImagetype sqlcommand.Parameters.Add(prmPersonImageType) Try sqlconn.Open() sqlcommand.ExecuteNonQuery() sqlconn.Close() Response.Write("New Image Added Successfully") Catch SQLex As SqlException Response.Write("Insert Failed. Error Details are: " & SQLex.ToString()) End Try End Sub </code> uSing Above I am Saving an Image to the Database and getting saved but Below is the Coding to retrive . but no Images are getting Displayed. <code> Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR")) Dim myCommand As New SqlCommand("Select * from Person", myConnection) Try myConnection.Open() Dim myDataReader As SqlDataReader myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) Do While (myDataReader.Read()) Response.BinaryWrite(myDataReader.Item("PersonImage")) Loop myConnection.Close() Response.Write("Person info successfully retrieved!") Catch SQLexc As SqlException Response.Write("Read Failed : " & SQLexc.ToString()) End Try End Sub </code> I am getting only the message retrived successfully but not image sathimailin

Last Visit: 31-Dec-99 18:00     Last Update: 1-May-24 12:36 Refresh ᐊ Prev1...2065206620672068206920702071207220732074 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.