ASP.NET, SQL Server, WPF, C#, VB.NET

What is the best method to create a linked server to a Paradox 5.0 database? 
 
Thanks in advance.

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

Hi, 
 
I was using MySQL before migrating to SQL Server 2005 Express. I didn't have 
 
any problems with SQLBindParameter when binding an SQL_CHAR param whose value 
 
was an empty string, but SQL Server doesn't seem to like it. 
 
At first I had set the ColumnSize to 0 -- which is probably what caused the 
 
HY104 Invalide precision value error. After changing the ColumnSize (say my 
 
column was a varchar(30) and i set columnsize to 30), I didn't get the error 
 
anymore, but I found that the  ...

My driver returns "03.51" for SQL_DRIVER_ODBC_VER in SQLGetInfoW. But the 
 
value that is actually returned to the application by DM is "03.00". How does 
 
DM determine this? Is there any thing missing or or wrong configuratuion? 
 
Thanks, 
 
Vivek

Hello, 
 
i've been searching the web since hours, but i found no real solutions. 
 
I'm using Oracle's Client 10.2 on Windows Server 2003. When i  connect 
 
to a DB over ODBC (Oracle's drivers), i'm getting an error: 
 
"im004 microsoft odbc driver manager driver's sqlallochandle on 
 
sql_handle_env failed" 
 
This happens only if "normal" users try to connect to the DB. Giving 
 
normal users admin-rights is no solution for me, because this machine 
 
is accessed over citrix by the whole com ...

I am in the middle of writing an ODBC driver.  Things were working okay until 
 
I decided to switch support to Unicode.  So far what I have done is change 
 
the project setting to use Unicode, change the function mention from 
 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcunicode_drivers.asp 
 
to end with a 'W' and change all SQLCHAR to SQLWCHAR.  Plus change the def 
 
file to export the functions with the 'W'. 
 
Now I seem to get corrupt pointers for the s ...

I am able to connect to a database set up on SQL windows 2003 under 
 
IIS. However I get an error message when I try to create a table. I am 
 
running from php. 
 
I am sure I am doing something stupid but I can't see it or could it 
 
be a permissions issue? 
 
Error - 
 
Connection to Database members Successful. 
 
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 
 
the keyword 'IF'. 
 
Code - 
 
//create a table in that dbase 
 
$sql ="CREATE TABLE IF NOT EXISTS $_SESSI ...

Hi 
 
I hope someone here can advise or at least point me to a good site to 
 
pursue this. 
 
Have installed a password protection system (freeware) successfully on 
 
a unix/php/mysql server and looking forward to developing it into a 
 
full blown database application. I is written in php and use a mysql 
 
database to hold user id's and passwords. There is a small amount of 
 
code on each protected page on the site that checks the session. 
 
I now need to set it up on a windows server syst ...

Hy. 
 
I have installed the ODBC driver NotesSQL vs. 3.0.2g on a Windows XP Ita Sp2 
 
fully updated. 
 
When I try to create a DSN via ODBC Manager the new driver doesn't appears. 
 
Any idea ? 
 
Thank you 
 
Roby

I am writing a multi threaded Client Server application. I have written a dll 
 
in .Net to perform the database related operations. I am using connection 
 
pooling. Now I have a function in the database dll. When multiple threads 
 
enter in that function , I am getting the imporper results. 
 
So , I thought of using transactions in that particualr function. But it is 
 
causing the deadlock in the application. 
 
Can anyone help me ? Is my desgin/architecture wrong > or there is something 
 
else i m missing > 
 
Regards

Dear Sir/Madam: 
 
Please let me ask you if I can register a 64-bit ODBC driver from a 32-bit 
 
application. 
 
On 64-bit Windows, I want to have my 32-bit setup program 
 
register/deregister both 32-bit and 64-bit ODBC drivers with the same driver 
 
name. Likewise, I want to have my 32-bit program create/delete ODBC data 
 
sources for both 32-bit and 64-bit applications with the same DSN and 
 
settings. My ODBC drivers are installed as follows: 
 
<InstallDir>\bin\MyODBCDriver.dll (32-b ...

the code copied below  throwsthis  error 
 
(val of ret is -2 
 
Total Number of diagnostic records: 0) 
 
I'm trying to do a bulk insert. 
 
column1 and column2 are both char [20][50] 
 
I can loop through these arrays and see their are values in them. 
 
The columns I'm trying to insert into are both char 16. 
 
rowcnt is 20. 
 
I could probably work it out if I had an example, but I cannot find 
 
one. I hope someone can help me, 
 
Kate 
 
code snippet 
 
ret = SQLSetStmtAttr(hstmt, SQL_ATTR ...

I am running ship construstor 2005, autocad 2005, greatplains, crystal 
 
reports 8. Everytime a user tries to pull a full report from 
 
shipconstructor database, they get the following error: 
 
Error-2147217871 ([Microsoft][ODBC SQL Server Driver]Timeout expired) 
 
in procedure FormatAndBindAssembly of Form frmAssemblyReportView 
 
I've tried changing the registry values on the client machine to 
 
timeout at 0 and double the time it takes to bomb out, under ODBC File 
 
DSN and under Jet-4. ...

I am running ship construstor 2005, autocad 2005, greatplains, crystal 
 
reports 8. Everytime a user tries to pull a full report from 
 
shipconstructor database, they get the following error: 
 
Error-2147217871 ([Microsoft][ODBC SQL Server Driver]Timeout expired) 
 
in procedure FormatAndBindAssembly of Form frmAssemblyReportView 
 
I've tried changing the registry values on the client machine to 
 
timeout at 0 and double the time it takes to bomb out, under ODBC File 
 
DSN and under Jet-4. ...

Hello all, 
 
Windows Server 2003 (Enterprise) 
 
AMD64 (Opeteron) 
 
SQL 2005 
 
Oracle 9i 
 
Please help. We are running SQL Server 2005 64bit on an Windows 2003 
 
Server Machine using AMD Opteron Processors. We are trying to setup 
 
linked servers to some Oracle 9i Databases on 32bit servers. We need 
 
to install ODBC/OLEDB providers for Oracle to achieve  this. we are 
 
having difficulty finding out a few things : 
 
i. How to install Microsoft OLEDB for Oracle - we have MDAC 2.8 
 
inst ...

OK, here's my quandary: If I develep a web app in VB.NET 2003, and access my 
 
data through ODBC, I have to choose an ODBC source at design time. What if I 
 
have multiple instances of the same app on one server, each of which is 
 
supposed to access a different ODBC datasource? I need another level of 
 
abstraction, so the app can decide which data source to look for at run time, 
 
right? How do I do that?

Successfully UpSized an access db to SQL. Created System DSN in ODBC. Can't 
 
connect using the db wizard in FP. 
 
Error Type: 
 
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) 
 
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database 
 
"database name" requested by the login. The login failed. 
 
/zz_test/global.asa, line 121 
 
This is all local and works with access db. Need education on the login???? 
 
Thanks!

Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri

Hi, 
 
Who knows good ODBC-driver for 
 
Infomix Server 10 DB's. 
 
(Not the IBM CSDK'-driver) 
 
Thanks

There seems to be a limit on logging of long sql statements in ODBC 
 
trace. 
 
For example if SELECT statement is longer than 2000 bytes just the 
 
first 2000 bytes are  logged. Similar limit seems to exist in Mimer 
 
ODBC Trace. 
 
Is there a way to increase logging buffer or any 3rd party odbc trace 
 
tool that can log the whole query?

We have a Windows 98 machine and an application that needs a SQL ODBC 
 
connection. Everything goes in correctly; we are able to enter the name 
 
of the data source and the server to connect to, we use trusted 
 
authentication. 
 
On the next window, we check the box for "Change the default database 
 
to:" the database that we need: MMSCFG. We go through the other windows 
 
and the test is successful. 
 
We close the window and are able to get into our application. The next 
 
time we resta ...

is possible to get the sql server login thru vba in Access 2003? 
 
thanks!

I have a server which I am connecting to over the Internet. 
 
Usually things are fine, but once in a while, when I open Enterprise 
 
Manager, it sees the server fine, but when I click Tools\Query Analyzer, the 
 
query analyzer fails to connect and says 
 
[odbc sql server driver] TCP/IP Sockets sql server does not exist or access 
 
denied 
 
then gives me the login screen.  This may happen all day long, and then the 
 
problem seems to go away and connections pop right up immediately. 
 
Whe ...

I am in the process of designing a specialized database in C#. I would 
 
like to connect to this database from some legacy programs that support 
 
ODBC. Is it possible to implement an ODBC driver in a .NET language, or 
 
would I need to rely on some form of interoperability technique so my 
 
C# database could respond to an ODBC driver written in C? Where can I 
 
find information about implementing an ODBC Driver? 
 
Thank you for any information. 
 
Scott Huey

Is it true that VC++ standalone apps will no longer be able to access a MS 
 
Access database (mdb) using the CDatabase and CRecordSet objects on a 64 bit 
 
machine? 
 
If yes, is there a workaround? 
 
Can I access a SQL Server 2005 Express data source using CDatabase class on 
 
a64 bit machine? 
 
Any help in the form of article references or comments will be extremely 
 
useful.