Connect To Mas90's File Using Their ODBC That They Setup?
Oct 21, 2009How do I connect to Mas90's file using their ODBC that they setup
View 10 RepliesHow do I connect to Mas90's file using their ODBC that they setup
View 10 Replieshow to connect to access using odbc since i did it already:
Imports System.Data.Odbc
......
Dim ODBC_CON As New OdbcConnection("dsn=DBMS Project")
[Code]....
how could i display it on the msgbox on the event that i clicked the button named "proceed" i provided much information as i could and same with as the code, i just need guide, simplest one for me to understand
how to connect to database using ODBC, where in connection string i will provide only DSN name. User id and Password should be entered dynamically. Like if i want to connect to SQL Server, I will provide dsn name, User id and password shud be entered dynamically. Already there is a form in SQL Server for Logging in, want to connect to tat?
View 2 RepliesWe have windows xp with sp3. The MDAC version on my machine is 2.81.1132.0. We notice that with this version of MDAC we are not able to connect to Microsoft ODBC driver for oracle. For MS ODBC to work we should have xp with sp2 or MDAC version 2.82.3959.0.
Is there any way to connect to MS ODBC using sp2 or version 2.81.1132.0 in XP?
I'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically?
[Code]...
In the old version Visual Basic 6, my code to connect to our Prophet 21 Progress database was:
Global DBConnect (5) as new ADODB.connection Global DBRec(5) as new ADODB.recordset Public Function Open_P21(SQL_Str As String, Ch As Integer, Status As Boolean)
[Code]...
I do need to connect oracle database via odbc in my vs 2005 project. I have no idea how to connect, kindly give me connection string codes and prerequisites.
View 7 Replieseverything works except for the Dim con As New OdbcConnection("DSN=yoh;") why?
imports System.Data.Odbc
Public Class Class1
Dim con As New OdbcConnection("DSN=yoh;")
Dim cmd As New OdbcCommand
[code]....
I'm trying to connect to Transoft U/SQL license using an odbc connection and and odbcDataAdapter. I am using a function to return a dataset into the mainModule.
HTML
dsOMD = getOMDinfo(psSerialNbr)
dtOMD = dsOMD.Tables(0)
The Function code that is being used is as follows:
HTML
Function getOMDinfo(ByVal strSerialNumber As String) As System.Data.DataSet
Dim myconnection1 = New OdbcConnection("DSN=omd.udd;uid=;")
Dim strSQL As String = String.Empty
[code]...
I am getting the following error:
Message: "ERROR [42000] [Transoft][TSODBC][usqlsd]Name expected ([)"
Source: "TSODBCW.DLL"
If I change the code to use a datareader it I can loop through the data but a data reader is not recommended to pass through the layers and so I'm wanting to create a dataset/data table process. Anyone have any ideas why the dataset/dataTable code is not working properly?
odbc driver not found unable to connectmysql 5.1 odbc already installed and i have the following code to connect mysql
Imports System.Data.Odbc
Conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;" + "DATABASE=apdata;UID=root;PASSWORD=acelle;Port=3306;"
[code].....
Setup and deploy for my project worked fine for a while allowing you to install my program and uninstall the old version, but now it installs two entries. I don't get it, before I got it do do that it would give an error that it needed to be uninstalled first. Now like I said I get two entries in the programs uninstall window. RemovePreviousVersions = true. I change the version number and update the product code. Even tried changing the upgrade code. I just don't get why it doesn't work anymore, and its really annoying! Also, is there a way that the setup file can just be one .exe rather then a setup file and a data file?
View 2 RepliesI have a small vb.net application that fires a crystal report through crystal viewer.
The report uses an ODBC connection provided by 32-bit software accounts package, which is installed in the ODBC 32-bit This all works fine on 32-bit XP and 32-bit Win7 with no problems, When run on a win7 64-bit machine the application launches ok, but when it comes to running the report, it prompts for a database logon box for the odbc connection.
When the report is run seperate on its own, on the exact same pc through crystal reports desginer it runs fine, Its almost like the application is not picking the 32-bit ODBC set up is it the case that the connection needs to be coded rather than using the report connection,
I'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 RepliesI'm having problems loading a csv file using dataadapter with ODBC command. Here's what I have:
Dim conn As OdbcConnection
Dim dt As New DataTable
Dim da As OdbcDataAdapter
Dim connectionString As String
Dim iFileRecords As Int32
[Code] .....
I get the following error:
"ERROR [42000] [Microsoft][ODBC Text Driver] Syntax error (missing operator) in query expression 'CAST([Preferred Phone Number] AS varchar(30))'."
The reason I was trying the CAST([Preferred Phone Number] AS varchar(30)) AS PNo was:
If all of the Phone Numbers are added with spaces e.g. 086 1234567, it works using SELECT [First Name], Surname, [Preferred Phone Number] AS PNo FROM [" & Me.ImpFileName & "]"
but if they are without i.e. 0861234567, it doesn't work hence trying to use CAST.
My guesses are to either force the import process to treat the [Preferred Phone Number] as text or get the CAST expresion to work but I've failed on both counts! I've tried the command in SQL database (albeit using SQL rather than ODBC connection) selecting from a table using CAST and it works fine.
I want to query a XML file (actual database) via odbc, but i do not know how and where to start and what program to use for it.
View 1 RepliesError Opening Excel File Read Only ODBC
View 1 RepliesI do one project in visual basic 2010.In visual basic 6 project can be make Package and deployment (setup file or install file) file using Package and deployment wizard.But in visual basic 2010 express edition does not have Package and deployment wizard.how to make Package and deployment (setup file or install file) file in visual basic 2010 project?
View 4 Repliesi am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 RepliesI'm trying to read a binary file from a FileMaker 11 container field using Filemaker's own ODBC driver. I was able to write files to the database and this works fine. retrieving them manually works fine and the files look OK and are not corupted. However when retreiving them using VB.NET, and if the file size is approx > 5MB, I get the following "uncatchable" error (yes thats right, I cant "Try Catch End Try", it just crashes):
System.AccessViolationException was unhandled
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
[code].....
I'm using ODBC to export tables from a dataset to an Excel file without auto-formatting Excel or even needing to have Excel installed on the users PC. This works great but I just had a request to autosize the columns and make the header line bold. The only way I know of doing this is to fully automate Excel to control the row/column/cell formatting. Does anyone know a way of doing this without auto-formatting Excel?
View 2 RepliesI want to create a real setup project for my application so when someone want to download it he can run only setup, not default setup that provide me VB . How can I do that?
View 4 RepliesI've developed a software using VB.Net and SQL compact edition database. (.sdf file) Now i want to add my .sdf file to setup file. I've search internet and create setup file. when i install the software, it is created new folders in program files including my database file and exe file. after double clicking exe file, it is open the software. but when using, it's shown a message "connection current state is closed". but when i run my vb project, it is working well.
Other details.
1) I create data base inside of /bin/debug
2) I've created setup file using this method. File menu --> add --> new project Then, Setup and deployment -> Visual studio installer After that I selected Setup project, then click OK.
3) I add database using this Right click on setup file -> add -> file (In solution explorer window) Then i selected my .sdf file.
This is my connection string
CODE:
It is created only 3 files in Program files.
1. my exe
2. my sdf file
3. System.Data.SqlServerCe.dll file
How can I include a batch file or an .exe file in my setup, that runs after setup is complete?
View 2 RepliesI'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
add serial number requirement to Setup & deployment > setup wizard for VB.net application
View 16 RepliesI am trying to create my exe file, so I go to build and build my project. Then I take the files in the bin else folder and try to run the exe file in another computer and it tells me that itīs missing some files like form designers and even dll files. It is trying to locate those files in the visual studio folder.
How can I make VB to include all the necessary files in the building proccess so I can run my exe file anywhere.
i have design my windows application in visual studio 2008 and i used crystal reports 2008.now i created a set up file which runs correctly in my system but when i run on other system its not running . tell me detail procedure (means step by step procedure) to create set up n which file to run on other system.
View 1 RepliesI want to deploy a VB6 application along with all the dependencies using VB.net installer (MSI). So can I execute VB6 Setup.exe (created using Package and Deployment Wizard) from the VB.NET installer (MSI).
View 2 RepliesI have create a program in vs 2008 (vb.net).When i finish the program i buildit and i create an msi file with shortcut in the desktop.I have run the setup and everything is gona be OK When i check my program i found an error and when i fix it a buildit again (Same Name) and i create also i new msi and setup file.In the second setup the program Override the old install and create a new shortcut.
View 2 Replieshow can i make the setup file to do whatever i want it to do via VB 2010 ultimate or anything else? I want the setup file when runs for first time to get the processor ID of that pc.Then i want it to save that ID. When i run it again in a different pc i want it to get the processor ID of the second pc and compare it with the one that it got and saved from the first one.If its the same it will run again.If its not the same then it wont run. Thats what i want it to do..
View 1 Replies