Encerrado

VB6 Linked Table Connection Function

I need a VB6 function to link tables in a SQL Server DB into an Access 2003 DB. The trick is the tables in SQL Server could be in a different Schema ie dbo_ or xyz_. The table names are the same except for the Schema.

I need the code to accept a comma delimited string of table names(without the Schema prefix) is "main,green,...) and fiind the appropriate table in the SQL server DB regardless of Schema and set up a linked table in an Access 2003 DB using the raw table name as the linked tablename (dbo_main in SQL server would be linked as main).

As parameters I will pass the string containing the raw table name and the SQL server connection string and the full path to the Access 2003 DB. Any other parameters if needed.

If there is an issue of refreshing the linked tables in the Access 2003 DB, the code should also include that before returning the function.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

VB6, SQL Server 2000 or 2005

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic, Visual Basic para Apps

Ver mais: vb6 0, the hire connection, string prefix, prefix string, prefix of a string, prefix function, linked on, linked n, linked i, is in a prefix, function - 1 to 1, linked, fiind, php function vb6, connection string access, run access function sql, code using vb6, program basic string, delimited access, vb6 receive, access linked table, access 2007 linked table, sql server linked server, raw php code, table linked access

Acerca do Empregador:
( 13 comentários ) United States

ID do Projeto: #2986710

7 freelancers are bidding on average $68 for this job

zhijun

See private message.

$85 USD in 4 dias
(25 Comentários)
5.2
kunlunli

See private message.

$85 USD in 4 dias
(12 Comentários)
5.0
alexeytvw

See private message.

$42.5 USD in 4 dias
(24 Comentários)
4.5
jawadaman

See private message.

$85 USD in 4 dias
(24 Comentários)
4.5
innocentfriend

See private message.

$68 USD in 4 dias
(2 Comentários)
1.4
derwood

See private message.

$25.5 USD in 4 dias
(2 Comentários)
1.3
vishalmverma

See private message.

$85 USD in 4 dias
(0 Comentários)
0.0